JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool
05A: PeopleSoft HR & PR Foundation
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F060116YA21114Employee Master InformationMaster Files05A: PeopleSoft HR & PR FoundationBusiness Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT YAAN8, YAALPH, YASSN, YAOEMP, YASEX, YAMSTX, YAMSTI, YAWSPS, YAEIC, YANDEP, YAEST, YAECNT, YATARR, YATARA, YASCDC, YAHMST, YAWKSE, YAHMLC, YALWK1, YALWK2, YAHMCO, YAMCU, YAHMCU, YASG, YAMAIL, YAPAST, YAPFRQ, YASALY, YAPYCB, YABCB, YAUN, YAJBCD, YAJBST, YAEEOJ, YAEEOM, YATRS, YAWCMP, YAFLSA, YAWS, YASHFT, YALMTH, YAPBRT, YALF, YASAL, YAPHRT, YAPPRT, YAPWRN, YAHRTN, YABRTN, YASALN, YASTDH, YASTDD, YASDYY, YAUSR, YAUFLG, YANS, YAIFN, YAIMN, YADOB, YADSI, YADT, YADST, YAPSDT, YAPTDT, YANRDT, YANBDT, YANPDT, YALCDT, YADR, YACTDT, YALADT, YABSDT, YACPDT, YAFICM, YAP001, YAP002, YAP003, YAP004, YAP005, YAP006, YAP007, YAP008, YAP009, YAP010, YAP011, YAP012, YAP013, YAP014, YAP015, YAP016, YAP017, YAP018, YAP019, YAP020, YAE001, YAE002, YAE003, YAE004, YAE005, YAE006, YAE007, YAE008, YAE009, YAE010, YAICC, YANMAX, YASOCC, YAIUSR, YAITRM, YAINBT, YAREGN, YAPSTP, YAIH, YACCPR, YAADPN, YATCNF, YARAF, YATIPE, YARCCD, YABDRT, YABORN, YANBDR, YAWET, YAAFLG, YARMST, YALMST, YASMKR, YACBAC, YACBAF, YAPCCD, YARCDT, YALSDT, YAPADT, YAPYMH, YAUYST, YADTSP, YAANN8, YAPPNB, YAPYDT, YACBEN, YADOBM, YADSTM, YAPSAL, YAHIPN, YACM, YALSAL, YADIVC, YAVSHF, YAPYRV, YAANPA, YAPGRD, YAPGRS, YASLOC, YANRVW, YATINC, YAHM01, YAHM02, YAHM03, YAHM04, YAPOS, YAED01, YAED02, YAED03, YAED04, YAED05, YAED06, YAED07, YAED08, YAED09, YAED10, YAED11, YAED12, YAED13, YAED14, YAED15, YAED16, YAED17, YAED18, YAED19, YAED20, YADEPT, YAFAGE, YAFSAL, YAADSD, YACMPA, YAEPNT, YAJOBN, YAUSER, YAPID, YAUPMJ, YAK001, YAK002, YAK003, YAK004, YAK005, YAK006, YAK007, YAK008, YAK009, YAK010, YAATPY, YAPENS, YAORG, YABENS, YAFTE, YAAAF, YASUI, YADTSF, YASMOY, YALDID, YATTAR FROM F060116

TOP920 | 05A | F060116 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1YAAN8Address NumberNumericGeneric Edit80 Allow NULL? 
2YAALPHName - AlphaStringGeneric Edit400 Allow NULL? 
3YASSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
4YAOEMPAdditional Employee NoStringGeneric Edit80 Allow NULL? 
5YASEXGender (Male/Female)CharacterUDC (07 SG)10 Allow NULL? 
6YAMSTXMarital Status - TaxCharacterUDC (06 MS)10 Allow NULL? 
7YAMSTIMarital Status - State TaxCharacterUDC (06 MS)10 Allow NULL? 
8YAWSPSResidency StatusCharacterUDC (05 WS)10 Allow NULL? 
9YAEICEarned Income Credit StatusCharacterUDC (05 EI)10 Allow NULL? 
10YANDEPDependentsNumericGeneric Edit20 Allow NULL? 
11YAESTEmployment StatusCharacterUDC (06 ES)10 Allow NULL? 
12YAECNTEmployee Classification StatusCharacterUDC (05A EC)10 Allow NULL? 
13YATARRTax Area (Residence)StringGeneric Edit100 Allow NULL? 
14YATARATax Area (Work)StringGeneric Edit100 Allow NULL? 
15YASCDCSchool District CodeNumericUDC (07 SS)50 Allow NULL? 
16YAHMSTState - HomeStringUDC (06 SC)30 Allow NULL? 
17YAWKSEState - WorkingStringUDC (06 SC)30 Allow NULL? 
18YAHMLCLocation - Home CityStringUDC (06 W1)30 Allow NULL? 
19YALWK1Location - Work CityStringUDC (06 W1)30 Allow NULL? 
20YALWK2Location - Work CountyStringUDC (06 W2)30 Allow NULL? 
21YAHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
22YAMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
23YAHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
24YASGLast Job WorkedStringGeneric Edit120 Allow NULL? 
25YAMAILRouting Code - CheckStringUDC (06 CR)100 Allow NULL? 
26YAPASTEmployee Pay StatusCharacterUDC (06 PS)10 Allow NULL? 
27YAPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
28YASALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
29YAPYCBPay Cycle Bypass CountNumericGeneric Edit20 Allow NULL? 
30YABCBBenefit Cycle Bypass CountNumericGeneric Edit20 Allow NULL? 
31YAUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
32YAJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
33YAJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
34YAEEOJJob Category (EEO)StringUDC (06 J)30 Allow NULL? 
35YAEEOMEthnic CodeStringUDC (06 M)20 Allow NULL? 
36YATRSChange ReasonStringUDC (06 T)30 Allow NULL? 
37YAWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
38YAFLSAFLSA Exempt Y/NCharacterUDC (05 FL)10 Allow NULL? 
39YAWSWork Schedule CodeCharacterUDC (05A WS)10 Allow NULL? 
40YASHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
41YALMTHLabor Distribution MethodCharacterUDC (07 LT)10 Allow NULL? 
42YAPBRTRate - Distribution (or Billing)NumericGeneric Edit93 Allow NULL? 
43YALFLabor Distribution MultiplierNumericGeneric Edit54 Allow NULL? 
44YASALRate - Salary AnnualNumericGeneric Edit112 Allow NULL? 
45YAPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
46YAPPRTRate - PieceworkNumericGeneric Edit93 Allow NULL? 
47YAPWRNRate (Piecework)at Next RaiseNumericGeneric Edit93 Allow NULL? 
48YAHRTNRate (Hourly) at Next RaiseNumericGeneric Edit93 Allow NULL? 
49YABRTNRate (Billing) at Next RaiseNumericGeneric Edit93 Allow NULL? 
50YASALNRate - Salary at Next RaiseNumericGeneric Edit112 Allow NULL? 
51YASTDHHours - Standard per PayperiodNumericGeneric Edit52 Allow NULL? 
52YASTDDHours - Standard per DayNumericGeneric Edit52 Allow NULL? 
53YASDYYDays - Standard per YearNumericGeneric Edit52 Allow NULL? 
54YAUSRPayroll Lockout IdentificationStringGeneric Edit180 Allow NULL? 
55YAUFLGUpdate FlagCharacterGeneric Edit10 Allow NULL? 
56YANSWork Tax Area SourceCharacterUDC (05 NS)10 Allow NULL? 
57YAIFNInitial - First Name (Govt Rpts)CharacterGeneric Edit10 Allow NULL? 
58YAIMNInitial - Middle Name (Govt Rpts)CharacterGeneric Edit10 Allow NULL? 
59YADOBDate - BirthDateGeneric Edit60
60YADSIDate - Original EmploymentDateGeneric Edit60
61YADTDate - TerminatedDateGeneric Edit60
62YADSTDate StartedDateGeneric Edit60
63YAPSDTDate - Pay StartsDateGeneric Edit60
64YAPTDTDate - Pay StopsDateGeneric Edit60
65YANRDTDate - Next RaiseDateGeneric Edit60
66YANBDTDate - New Bill RateDateGeneric Edit60
67YANPDTDate - New PiecerateDateGeneric Edit60
68YALCDTDate - Last CheckDateGeneric Edit60
69YADRDate - Last RaiseDateGeneric Edit60
70YACTDTDate - Last ContactDateGeneric Edit60
71YALADTDate - LOA Expiration DateDateGeneric Edit60
72YABSDTDate - BonusDateGeneric Edit60
73YACPDTDate - Current PositionDateGeneric Edit60
74YAFICMTax Calc MethodCharacterUDC (06 TM)10 Allow NULL? 
75YAP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
76YAP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
77YAP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
78YAP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
79YAP005Category Codes - Payroll5StringUDC (06 05)30 Allow NULL? 
80YAP006Category Codes - Payroll6StringUDC (06 06)30 Allow NULL? 
81YAP007Category Codes - Payroll7StringUDC (06 07)30 Allow NULL? 
82YAP008Category Codes - Payroll8StringUDC (06 08)30 Allow NULL? 
83YAP009Category Codes - Payroll9StringUDC (06 09)30 Allow NULL? 
84YAP010Category Codes - Payroll10StringUDC (06 10)30 Allow NULL? 
85YAP011Category Codes - Payroll11StringUDC (06 11)30 Allow NULL? 
86YAP012Category Codes - Payroll12StringUDC (06 12)30 Allow NULL? 
87YAP013Category Codes - Payroll13StringUDC (06 13)30 Allow NULL? 
88YAP014Category Codes - Payroll14StringUDC (06 14)30 Allow NULL? 
89YAP015Category Codes - Payroll15StringUDC (06 15)30 Allow NULL? 
90YAP016Category Codes - Payroll16StringUDC (06 16)30 Allow NULL? 
91YAP017Category Codes - Payroll17StringUDC (06 17)30 Allow NULL? 
92YAP018Category Codes - Payroll18StringUDC (06 18)30 Allow NULL? 
93YAP019Category Codes - Payroll19StringUDC (06 19)30 Allow NULL? 
94YAP020Category Codes - Payroll20StringUDC (06 21)30 Allow NULL? 
95YAE001Eligibility Code 001CharacterUDC (05 YB)10 Allow NULL? 
96YAE002Eligibility Code 002CharacterUDC (05 YB)10 Allow NULL? 
97YAE003Eligibility Code 003CharacterUDC (05 YB)10 Allow NULL? 
98YAE004Eligibility Code 004CharacterUDC (05 YB)10 Allow NULL? 
99YAE005Eligibility Code 005CharacterUDC (05 YB)10 Allow NULL? 
100YAE006Eligibility Code 006CharacterUDC (05 YB)10 Allow NULL? 
101YAE007Eligibility Code 007CharacterUDC (05 YB)10 Allow NULL? 
102YAE008Eligibility Code 008CharacterUDC (05 YB)10 Allow NULL? 
103YAE009Eligibility Code 009CharacterUDC (05 YB)10 Allow NULL? 
104YAE010Eligibility Code 010CharacterUDC (05 YB)10 Allow NULL? 
105YAICCInterim Check CodeCharacterUDC (07 IC)10 Allow NULL? 
106YANMAXAmount - Maximum Net PayNumericGeneric Edit152 Allow NULL? 
107YASOCCStandard Occupational Class CodeStringUDC (06 SO)40 Allow NULL? 
108YAIUSRUser ID - Interim Check EntererStringGeneric Edit100 Allow NULL? 
109YAITRMTerminal Id - Interim CheckStringGeneric Edit100 Allow NULL? 
110YAINBTInterim Processing Batch FlagCharacterUDC10 Allow NULL? 
111YAREGNRegionStringUDC (06 RG)30 Allow NULL? 
112YAPSTPNo. of Pay Grade StepsStringGeneric Edit40 Allow NULL? 
113YAIHHours per Standard YearNumericGeneric Edit72 Allow NULL? 
114YACCPRCountry CodeStringUDC (00 CN)30 Allow NULL? 
115YAADPNPre-Note CodeCharacterUDC (07 AE)10 Allow NULL? 
116YATCNFThird Country National FlagCharacterGeneric Edit10 Allow NULL? 
117YARAFResident Alien FlagCharacterGeneric Edit10 Allow NULL? 
118YATIPEEmployee Code - Tipped(Y/N)CharacterUDC (05 YN)10 Allow NULL? 
119YARCCDRecord TypeCharacterUDC (07 RC)10 Allow NULL? 
120YABDRTRate - Recharge BurdenNumericGeneric Edit93 Allow NULL? 
121YABORNRate - New Recharge Burden RateNumericGeneric Edit93 Allow NULL? 
122YANBDRDate - New Bill RateDateGeneric Edit60
123YAWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
124YAAFLGAddress FlagCharacterGeneric Edit10 Allow NULL? 
125YARMSTMarital Status - Resident StateCharacterUDC (06 MS)10 Allow NULL? 
126YALMSTLocal Area Marital StatusCharacterUDC (06 MS)10 Allow NULL? 
127YASMKRFlag - Language PreferenceStringUDC (07 SN)20 Allow NULL? 
128YACBACAmount - Cash AccumulatorNumericGeneric Edit32 Allow NULL? 
129YACBAFFlag - Cash RoundingCharacterGeneric Edit10 Allow NULL? 
130YAPCCDPay Cycle CodeStringUDC (06 PY)50 Allow NULL? 
131YARCDTDate - Employee RecallDateGeneric Edit60
132YALSDTDate - LOA Beginning DateDateGeneric Edit60
133YAPADTDate - ParticipationDateGeneric Edit60
134YAPYMHMethod - Employee PaymentCharacterUDC10 Allow NULL? 
135YAUYSTProcessed Code - PayrollCharacterUDC10 Allow NULL? 
136YADTSPDate - Time StampNumericGeneric Edit130 Allow NULL? 
137YAANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
138YAPPNBPay Period NumberStringGeneric Edit30 Allow NULL? 
139YAPYDTDate - Pay Cycle ProcessedDateGeneric Edit60
140YACBENCash BenefitCharacterUDC (05 YN)10 Allow NULL? 
141YADOBMBirthday - MonthNumericGeneric Edit20 Allow NULL? 
142YADSTMStartdate - MonthNumericGeneric Edit20 Allow NULL? 
143YAPSALRate - Previous SalaryNumericGeneric Edit112 Allow NULL? 
144YAHIPNMedical Plan IDStringGeneric Edit110 Allow NULL? 
145YACMCredit MessageStringUDC (00 CM)20 Allow NULL? 
146YALSALRate - Life Ins. Annual SalaryNumericGeneric Edit132 Allow NULL? 
147YADIVCBenefit GroupStringGeneric Edit60 Allow NULL? 
148YAVSHFShares Flag - VotingCharacterUDC (05 YN)10 Allow NULL? 
149YAPYRVPrior Years for Calculating VestingNumericGeneric Edit53 Allow NULL? 
150YAANPASupervisorNumericGeneric Edit80 Allow NULL? 
151YAPGRDPay GradeStringGeneric Edit60 Allow NULL? 
152YAPGRSPay Grade StepStringGeneric Edit40 Allow NULL? 
153YASLOCSalary Data LocalityStringUDC (06 SL)80 Allow NULL? 
154YANRVWDate - Next ReviewDateGeneric Edit60
155YATINCType of Increase Next ReviewCharacterUDC (06 RV)10 Allow NULL? 
156YAHM01EEO - I9 StatusCharacterUDC (07 HN)10 Allow NULL? 
157YAHM02EEO - VeteranCharacterUDC (05 HO)10 Allow NULL? 
158YAHM03EEO - Disabled VeteranCharacterUDC (05 HP)10 Allow NULL? 
159YAHM04EEO - DisabilityCharacterUDC (05 HQ)10 Allow NULL? 
160YAPOSPosition IDStringGeneric Edit80 Allow NULL? 
161YAED01Date - User Defined1DateGeneric Edit60
162YAED02Date - User Defined2DateGeneric Edit60
163YAED03Date - User Defined3DateGeneric Edit60
164YAED04Date - User Defined4DateGeneric Edit60
165YAED05Date - User Defined5DateGeneric Edit60
166YAED06Date - User Defined6DateGeneric Edit60
167YAED07Date - User Defined7DateGeneric Edit60
168YAED08Date - User Defined8DateGeneric Edit60
169YAED09Date - User Defined9DateGeneric Edit60
170YAED10Date - User Defined10DateGeneric Edit60
171YAED11Date - User Defined11DateGeneric Edit60
172YAED12Date - User Defined12DateGeneric Edit60
173YAED13Date - User Defined13DateGeneric Edit60
174YAED14Date - User Defined14DateGeneric Edit60
175YAED15Date - User Defined15DateGeneric Edit60
176YAED16Date - User Defined16DateGeneric Edit60
177YAED17Date - User Defined17DateGeneric Edit60
178YAED18Date - User Defined18DateGeneric Edit60
179YAED19Date - User Defined19DateGeneric Edit60
180YAED20Date - User Defined20DateGeneric Edit60
181YADEPTDepartment CodeStringGeneric Edit120 Allow NULL? 
182YAFAGEAge - EmployeeNumericGeneric Edit30 Allow NULL? 
183YAFSALRate - Life Ins. Annual SalaryNumericGeneric Edit152 Allow NULL? 
184YAADSDDate - Adjusted Service DateDateGeneric Edit60
185YACMPACompa-RatioNumericGeneric Edit52 Allow NULL? 
186YAEPNTJob Evaluation PointsNumericGeneric Edit50 Allow NULL? 
187YAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
188YAUSERUser IDStringGeneric Edit100 Allow NULL? 
189YAPIDProgram IDStringGeneric Edit100 Allow NULL? 
190YAUPMJDate - UpdatedDateGeneric Edit60
191YAK001401(k) Non-Discrimination Test1CharacterGeneric Edit (05 OO)10 Allow NULL? 
192YAK002401(k) Non-Discrimination Test2CharacterGeneric Edit (05 YB)10 Allow NULL? 
193YAK003401(k) Non-Discrimination Test3CharacterGeneric Edit (05 YB)10 Allow NULL? 
194YAK004401(k) Non-Discrimination Test4CharacterGeneric Edit (05 YB)10 Allow NULL? 
195YAK005401(k) Non-Discrimination Test5CharacterGeneric Edit (05 YB)10 Allow NULL? 
196YAK006401(k) Non-Discrimination Test6CharacterGeneric Edit (05 YB)10 Allow NULL? 
197YAK007401(k) Non-Discrimination Test7CharacterGeneric Edit (05 YB)10 Allow NULL? 
198YAK008401(k) Non-Discrimination Test8CharacterGeneric Edit (05 YB)10 Allow NULL? 
199YAK009401(k) Non-Discrimination Test9CharacterGeneric Edit (05 YB)10 Allow NULL? 
200YAK010401(k) Non-Discrimination Test10CharacterGeneric Edit (05 YB)10 Allow NULL? 
201YAATPYPayroll Autopay PaytypeNumericUDC (06 20)30 Allow NULL? 
202YAPENSPension CodeCharacterUDC (05 YB)10 Allow NULL? 
203YAORGOrgeon InsuranceCharacterUDC (05A OR)10 Allow NULL? 
204YABENSEmployee Benefit StatusCharacterUDC (06 EA)10 Allow NULL? 
205YAFTEFull Time EquivalentsNumericGeneric Edit92 Allow NULL? 
206YAAAFVacation FactorCharacterUDC (07 AA)10 Allow NULL? 
207YASUISource of SUI ReportingCharacterUDC (05 SR)10 Allow NULL? 
208YADTSFSalary Forecast Change DateDateGeneric Edit60
209YASMOYPeriods Paid Per YearNumericGeneric Edit52 Allow NULL? 
210YALDIDLabor Distribution Period IDStringUDC (05T LD)50 Allow NULL? 
211YATTARTotal Time Accounting RulesCharacterUDC (05T TA)10 Allow NULL? 

TOP920 | 05A | F060116 INDEXES

NumberDescription
1AddressNumber (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2Social Security Number
ElementAliasDescriptionSequence
1SSNEmployee Tax IDAscending
5Home BU Job Code +A
ElementAliasDescriptionSequence
1HMCUBusiness Unit - HomeAscending
2JBCDJob Type (Craft) CodeAscending
3JBSTJob StepDescending
4ALPHName - AlphaAscending
6Job Code Job Step +A
ElementAliasDescriptionSequence
1JBCDJob Type (Craft) CodeAscending
2JBSTJob StepDescending
3ALPHName - AlphaAscending
7PR Lockout ID Update Flag
ElementAliasDescriptionSequence
1USRPayroll Lockout IdentificationAscending
2UFLGUpdate FlagAscending
8Date Next Rev Supervisor +A
ElementAliasDescriptionSequence
1NRVWDate - Next ReviewAscending
2ANPASupervisorAscending
3TINCType of Increase Next ReviewAscending
9Supervisor Type of Inc +A
ElementAliasDescriptionSequence
1ANPASupervisorAscending
2TINCType of Increase Next ReviewAscending
3NRVWDate - Next ReviewAscending
10Type of Inc Supervisor +A
ElementAliasDescriptionSequence
1TINCType of Increase Next ReviewAscending
2ANPASupervisorAscending
3NRVWDate - Next ReviewAscending
11Home BU Check Route Code +A (Unique)
ElementAliasDescriptionSequence
1HMCUBusiness Unit - HomeAscending
2MAILRouting Code - CheckAscending
3AN8Address NumberAscending
12Supervisor Address Number (Unique)
ElementAliasDescriptionSequence
1ANPASupervisorAscending
2AN8Address NumberAscending
13Address Number Supervisor (Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2ANPASupervisorAscending
14Address Number Job Type A+
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2JBCDJob Type (Craft) CodeAscending
3JBSTJob StepAscending
15Alternate Employee Number
ElementAliasDescriptionSequence
1OEMPAdditional Employee NoAscending
17Company Home Union Code A+
ElementAliasDescriptionSequence
1HMCOCompany - HomeAscending
2UNUnion CodeAscending
3HMCUBusiness Unit - HomeAscending
4AN8Address NumberAscending