| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | RUNID | HR B2A: Global Object ID | nvarchar | 32 | 0 | CHAR | (N' ') | No | | PC_B2A_GLBID | Allow NULL? |
| 3 | PERNR | Personnel number | nvarchar | 8 | 0 | NUMC | (N'00000000') | No | * | PERSNO | Allow NULL? |
| 4 | SRNO | Super Stream Unique running sequence number | nvarchar | 10 | 0 | NUMC | (N'0000000000') | No | | P13Q_SRNO | Allow NULL? |
| 5 | STATUS | Status of Record | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | P13Q_STATUS | Allow NULL? |
| 6 | SEQNR | Sequence Number | nvarchar | 5 | 0 | NUMC | (N'00000') | Yes | | CDSEQ | Allow NULL? |
| 7 | IABKRS | Payroll Area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | * | ABKRS | Allow NULL? |
| 8 | INPER | In-period for payroll | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | IPERI | Allow NULL? |
| 9 | FPPER | For-period for garnishment | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | FPPER | Allow NULL? |
| 10 | PAYTY | Payroll type | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYTY | Allow NULL? |
| 11 | PAYID | Payroll Identifier | char | 1 | 0 | CHAR | (N' ') | Yes | | PAYID | Allow NULL? |
| 12 | BONDT | Off-cycle payroll payment date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BONDT | Allow NULL? |
| 13 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PAY_DATE | Allow NULL? |
| 14 | SDATE | Date of updation of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_SDATE | Allow NULL? |
| 15 | STIME | Time of update of record | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | P13_STIME | Allow NULL? |
| 16 | SUSER | User Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | UNAME | Allow NULL? |
| 17 | PRN2 | Payment Reference Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | P13Q_PRN | Allow NULL? |
| 18 | FCODE | Superannuation Fund Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | P13Q_FCODE | Allow NULL? |
| 19 | NEGSP | Negatives Supported | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | | P13_NEGSP | Allow NULL? |
| 20 | FILID | FILE ID | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | P13_FILEID | Allow NULL? |
| 21 | BUKRS | Company Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BUKRS | Allow NULL? |
| 22 | LINID | LINE ID | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | P13_LINEID | Allow NULL? |
| 23 | SOUID | Source Entity ID | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | P13_SRCEID | Allow NULL? |
| 24 | SOENT | Source Entity ID Type | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_SOUENTY | Allow NULL? |
| 25 | SOADD | Source Electronic Service Address | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_SOUADD | Allow NULL? |
| 26 | ERMSG | Electronic Error Messaging | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_ERRMSG | Allow NULL? |
| 27 | SEABN | HR AU: Super Stream Source ABN | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | P13_SUPFABN | Allow NULL? |
| 28 | SORGN | Sender Organization Name | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_ORGNM | Allow NULL? |
| 29 | SFNAM | Sender Family Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_SFNAM | Allow NULL? |
| 30 | SGNAM | Sender Given Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_SGNAM | Allow NULL? |
| 31 | SONAM | Sender Other Given Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_SONAM | Allow NULL? |
| 32 | SEMAL | Sender E-mail Address Text | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_SEMAIL | Allow NULL? |
| 33 | STELN | Telephone Contact Number | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_TELNO | Allow NULL? |
| 34 | PAABN | Payer ABN | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | P13_PABN | Allow NULL? |
| 35 | PORGN | Payer Organization Name | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P13Q_ORGNAME1 | Allow NULL? |
| 36 | PABSB | Bank State Branch Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | P13_SBRNO | Allow NULL? |
| 37 | PAACN | Financial Institution Account Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_FACNO | Allow NULL? |
| 38 | PACNT | Financial Institution Account Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_FACNM | Allow NULL? |
| 39 | PYABN | HR AU: Super Stream Target ABN | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | P13_SUPTABN | Allow NULL? |
| 40 | PYUSI | Unique Superannuation Identification Number | nvarchar | 14 | 0 | CHAR | (N' ') | Yes | | P13_USINO | Allow NULL? |
| 41 | PYORG | Fund Organization Name | nvarchar | 60 | 0 | CHAR | (N' ') | Yes | | P13Q_ORGNAME2 | Allow NULL? |
| 42 | PYTAD | End Point URL | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_EPURL | Allow NULL? |
| 43 | PYMTH | Payment Method | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | P13_PAYMD | Allow NULL? |
| 44 | TRNDT | Payment Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_PAYDT | Allow NULL? |
| 45 | PRNUM | Payment Reference Number | nvarchar | 18 | 0 | CHAR | (N' ') | Yes | | P13Q_PRN | Allow NULL? |
| 46 | BPAYC | BPay Biller Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_BPBCD | Allow NULL? |
| 47 | PYAMT | Super Stream Payment Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_SUPAMNT | |
| 48 | PYBSB | Bank State Branch Number | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | | P13_SBRNO | Allow NULL? |
| 49 | PYACN | Financial Institution Account Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_FACNO | Allow NULL? |
| 50 | PYACT | Financial Institution Account Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_FACNM | Allow NULL? |
| 51 | ERABN | Employer ABN | nvarchar | 11 | 0 | NUMC | (N'00000000000') | Yes | | P13_EABN | Allow NULL? |
| 52 | LOCID | Location ID | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | P13_LOCID | Allow NULL? |
| 53 | EORGN | Employer Organizational Name Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_EORGNAM | Allow NULL? |
| 54 | FNDGE | Superannuation Fund Generated Employer Identifier | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13Q_EMPLR | Allow NULL? |
| 55 | TAXFN | Tax File Number (TFN) | nvarchar | 9 | 0 | NUMC | (N'000000000') | Yes | | P13Q_TAXFN | Allow NULL? |
| 56 | NTITL | Person Name Title Text | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | P13_NTITL | Allow NULL? |
| 57 | NSUFX | Person Name Suffix text | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | P13_NSUFX | Allow NULL? |
| 58 | PFNAM | Member Family Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_PFNAM | Allow NULL? |
| 59 | PGNAM | Member Given Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_PGNAM | Allow NULL? |
| 60 | PONAM | Member Other Given Name | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_PONAM | Allow NULL? |
| 61 | SEXCD | Sex Code | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P13_SEXCODE | Allow NULL? |
| 62 | BDATE | Date of Birth | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | GBDAT | Allow NULL? |
| 63 | ADRCO | Address Usage Code | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | P13_ADDCD | Allow NULL? |
| 64 | ADDL1 | Address Details Line 1 Text | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P13_ADL1 | Allow NULL? |
| 65 | ADDL2 | Address Details Line 2 Text | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P13_ADL2 | Allow NULL? |
| 66 | ADDL3 | Address Details Line 3 Text | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P13_ADL3 | Allow NULL? |
| 67 | ADDL4 | Address Details Line 4 Text | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P13_ADL4 | Allow NULL? |
| 68 | LOCNM | Locality Name Text | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P13_LOCNAM | Allow NULL? |
| 69 | PSTCD | Postal Code | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTLZ_HR | Allow NULL? |
| 70 | STACO | State or Territory Code | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | P13_STATCO | Allow NULL? |
| 71 | CNTRY | Country Key | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND1 | Allow NULL? |
| 72 | MEMAL | E-mail Address | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_EADDR | Allow NULL? |
| 73 | MEMTL | Member Telephone Minimal Number Landline | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_MTELNO | Allow NULL? |
| 74 | MEMMB | Member Telephone Minimal Number Mobile | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_MMOBNO | Allow NULL? |
| 75 | MEMID | Member Client Identifier | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_MEMIDEN | Allow NULL? |
| 76 | PAYNO | Payroll Number Identifier | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | * | P13_PAYIDN | Allow NULL? |
| 77 | EMPEN | Employee Employment End date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_EMPENDT | Allow NULL? |
| 78 | EMPET | Employment End Reason Text | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | P13_EMPENDTEXT | Allow NULL? |
| 79 | PSTDT | Pay Period Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_PSRTDT | Allow NULL? |
| 80 | PENDT | Pay Period End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_PENDT | Allow NULL? |
| 81 | SAGAM | Employer Super Annuation Guarantee Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_SGCAMT | |
| 82 | AWDAM | Employer Contributions Award Or Productivity Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_AWDAMT | |
| 83 | PCONT | Employee Personal Contributions Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_EECAMT | |
| 84 | SALSC | Employer Contributions Salary Sacrificed Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_SCFAMT | |
| 85 | VOLAM | Employer Voluntary contribution amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_ERVOL | |
| 86 | SPCON | Spouse Contribution Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_SPOUSE | |
| 87 | CHCON | Child Contribution Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_CHILD | |
| 88 | OTCON | Third Party Contribution Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_3PCNTR | |
| 89 | EMSTD | Employment Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_EMSTDT | Allow NULL? |
| 90 | ATWRK | At Work Indicator | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | P13_ATWRK | Allow NULL? |
| 91 | ANBEN | Annual Salary for Benefits Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_ANBEN | |
| 92 | ANCON | Annual Salary for Contributions Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_ANSALCON | |
| 93 | ACONS | Super Contribution Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_CONTSTDAT | Allow NULL? |
| 94 | ACONE | Super Contribution End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_CONTENDAT | Allow NULL? |
| 95 | AINAM | Annual Salary for Insurance Amount | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_ANSALINS | |
| 96 | WHRSW | Weekly Hours Worked Number | decimal | 5 | 2 | DEC | ((0)) | Yes | | P13_WHRS | |
| 97 | OCCUD | Occupation Description | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_OCCDS | Allow NULL? |
| 98 | INSIN | Insurance Opt Out Indicator | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | P13_INSIN | Allow NULL? |
| 99 | FNDRG | Super Fund Registration Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_FUNDREGDT | Allow NULL? |
| 100 | BENCT | Benefit Category | nvarchar | 120 | 0 | CHAR | (N' ') | Yes | | P13_BNFCT | Allow NULL? |
| 101 | EMPST | HR AU: Employment Status Of Employee | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_EMP_STAT | Allow NULL? |
| 102 | COSDT | Super Contribution Commence Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_CONTCOMDAT | Allow NULL? |
| 103 | COEDT | Super Contribution Cease Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_CONTCEADAT | Allow NULL? |
| 104 | MEMRT | Member Registration Text | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | P13_REGTX | Allow NULL? |
| 105 | MPRTX | Defined Benefit Member Pre Tax Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBPRT | |
| 106 | MPOTC | Defined Benefit Member Post Tax Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBPOT | |
| 107 | DBERC | Defined Benefit Employer Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBERCON | |
| 108 | NMPRT | Defined Benefit Notional Member Pre Tax Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBNPRT | |
| 109 | NMPOT | Defined Benefit Notional Member Post Tax Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBNPOT | |
| 110 | NOERC | Defined Benefit Notional Employer Contribution | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBNERCON | |
| 111 | ORTER | Ordinary Time Earnings | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBOTE | |
| 112 | APSWE | Actual Periodic Salary or Wages Earned | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBAPS | |
| 113 | SUAPD | Superannuable Allowances Paid | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBSAP | |
| 114 | NSUAP | Notional Superannuable Allowances | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBNSAP | |
| 115 | SERFR | Service Fraction | decimal | 6 | 5 | DEC | ((0)) | Yes | | P13_DBSFR | |
| 116 | SERED | Service Fraction Effective Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBSED | Allow NULL? |
| 117 | FUTHR | Full Time Hours | decimal | 7 | 3 | DEC | ((0)) | Yes | | P13_DBFTH | |
| 118 | CONHR | Contracted Hours | decimal | 7 | 3 | DEC | ((0)) | Yes | | P13_DBCNH | |
| 119 | ACHRP | Actual Hours Paid | decimal | 7 | 3 | DEC | ((0)) | Yes | | P13_DBAHP | |
| 120 | EMLOC | Employee Location Identifier | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_DBELOC | Allow NULL? |
| 121 | DSERF | Defined Benefits Registration Service Fraction | decimal | 6 | 5 | DEC | ((0)) | Yes | | P13_DBRSF | |
| 122 | DSERS | Service Fraction Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBRSD | Allow NULL? |
| 123 | DSERE | Service Fraction End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBRSED | Allow NULL? |
| 124 | EMPRT | Defined Benefit Employer Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | P13_DBRER | |
| 125 | EMPRS | Defined Benefit Employer Rate Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBERS | Allow NULL? |
| 126 | EMPRE | Defined Benefit Employer Rate End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBERE | Allow NULL? |
| 127 | MERAT | Defined Benefit Member Rate | decimal | 5 | 2 | DEC | ((0)) | Yes | | P13_DBMRT | |
| 128 | MERAS | Defined Benefit Member Rate Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBMRS | Allow NULL? |
| 129 | MERAE | Defined Benefit Member Rate End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBMRE | Allow NULL? |
| 130 | ANSA1 | Defined Benefit Annual Salary 1 | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBAS1 | |
| 131 | ANSD1 | Defined Benefit Annual Salary 1 Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASS1 | Allow NULL? |
| 132 | ANSE1 | Defined Benefit Annual Salary 1 End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASE1 | Allow NULL? |
| 133 | ANSA2 | Defined Benefit Annual Salary 2 | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBAS2 | |
| 134 | ANSD2 | Defined Benefit Annual Salary 2 Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASS2 | Allow NULL? |
| 135 | ANSE2 | Defined Benefit Annual Salary 2 End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASE2 | Allow NULL? |
| 136 | ANSA3 | Defined Benefit Annual Salary 3 | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBAS3 | |
| 137 | ANSD3 | Defined Benefit Annual Salary 3 Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASS3 | Allow NULL? |
| 138 | ANSE3 | Defined Benefit Annual Salary 3 End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASE3 | Allow NULL? |
| 139 | ANSA4 | Defined Benefit Annual Salary 4 | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBAS4 | |
| 140 | ANSD4 | Defined Benefit Annual Salary 4 Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASS4 | Allow NULL? |
| 141 | ANSE4 | Defined Benefit Annual Salary 4 End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASE4 | Allow NULL? |
| 142 | ANSA5 | Defined Benefit Annual Salary 5 | decimal | 13 | 2 | CURR | ((0)) | Yes | | P13_DBAS5 | |
| 143 | ANSD5 | Defined Benefit Annual Salary 5 Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASS5 | Allow NULL? |
| 144 | ANSE5 | Defined Benefit Annual Salary 5 End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBASE5 | Allow NULL? |
| 145 | LWPCD | Leave Without Pay Code | char | 1 | 0 | NUMC | (N'0') | Yes | | P13_DBLWPC | Allow NULL? |
| 146 | LWPCS | Leave Without Pay Code Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBLWPS | Allow NULL? |
| 147 | LWPCE | Leave Without Pay Code End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_DBLWPE | Allow NULL? |
| 148 | ASIED | Annual Salary for Insurance Effective Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_ASIED | Allow NULL? |
| 149 | ASBED | Annual Salary for Benefits Effective Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_ASBED | Allow NULL? |
| 150 | EMSED | Employee Status Effective Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_ESED | Allow NULL? |
| 151 | EBEND | Employee Benefit Category Effective Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_EBCED | Allow NULL? |
| 152 | DEMLC | Employee Location Identifier | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | P13_DBELOC | Allow NULL? |
| 153 | DEMLS | Employee Location Identifier Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_ELOCS | Allow NULL? |
| 154 | DEMLE | Employee Location Identifier End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | P13_ELOCE | Allow NULL? |
