| Table | Table Description | Column# | Prefix | Alias | Column Description | Data Type | Edit Type | Length | Decimals |
---|
TOP00: Foundation Environment |
1 | F0911 | Account Ledger | 90 | GL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP05: Time Accounting and HRM Base |
2 | F050116W | Employee Master Integrations Work File | 7 | EM | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
3 | F05102 | Goal Master | 13 | SM | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
4 | F05105 | Goal Suggestions | 12 | GS | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
5 | F0609 | Deduction/Benefit/Accrual Ledger File | 18 | Y$ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
6 | F06106 | Employee Pay Instructions | 58 | YM | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
7 | F0618 | Employee Transaction History | 43 | YT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
8 | F0619 | Benefit/Accrual Detail File | 18 | Y$ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
9 | F0625 | Change Code History File | 2 | JB | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
10 | F06251 | Step Progression Rate History File | 4 | JB | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
11 | F069106 | Union Benefits Master | 2 | Y1 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
12 | F069126 | Union Rates File | 5 | YL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
13 | F0691261 | Additional Union Rates | 5 | YL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
14 | F06915 | Holiday Table | 5 | JH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
15 | F069150 | DBA Group Plan Group Limit Overrides | 3 | Y1 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
16 | F069162 | Job Type/ Item Cross Reference File | 1 | JH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
17 | F06923 | Valid Job Type/ Step Constant | 2 | YH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
18 | F06925 | Employee/Vendor Cross Reference | 3 | YG | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
19 | F06933 | Step Progression Parameters | 5 | J@ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
20 | F06936 | Retro Pay Types Rate | 6 | JA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
21 | F0709 | Deduction/Benefit/Accrual Ledger File | 23 | Y$ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP05A: PeopleSoft HR & PR Foundation |
22 | F060116 | Employee Master Information | 32 | YA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
23 | F0601161 | Point-In-Time Employee Master | 34 | PT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
24 | F060116W | EE Master Request File | 32 | YA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
25 | F060116Z | Unedited Quick Hire Transaction File | 25 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
26 | F060119 | Employee Jobs History File | 3 | YE | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
27 | F06345 | Historical Payroll Register | 11 | JL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
28 | F069056 | Establishment Constant File | 10 | YO | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP05T: Time Entry |
29 | F06022 | Employee Piecerate File | 19 | JA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
30 | F06116 | Employee Transaction Detail File | 43 | YT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
31 | F06116Z1 | Employee Transactions - Batch File | 55 | VL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
32 | F06116Z2 | ESS Timecard History | 55 | VM | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
33 | F06278 | Retro Timecard Detail File | 41 | YT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
34 | F06290 | Payroll Accounting Journal Work File | 18 | YR | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
35 | F063951 | Payroll Journal (Compressed) File | 27 | GL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
36 | F06904 | Automatic Accounting Instructions | 19 | Y# | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
37 | F069136 | Tip Disbursement | 6 | JE | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
38 | F06918 | PF - Piece Rate File | 3 | JN | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
39 | F069306 | Union Local Cross Reference | 3 | Y@ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
40 | F06932 | Classification/Pay Cross Reference | 1 | J4 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP06: Payroll (old) - Obsolete-do not reuse |
41 | F060118 | Employee Jobs | 3 | YE | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
42 | F060146 | Employees Pay Rate File | 4 | JI | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP07: Payroll |
43 | F05290 | WF - Payroll Journal (Detail) | 27 | JR | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
44 | F06270 | Retro Processing Parameter | 44 | JP | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
45 | F063106 | Deduction/Benefit Work File | 9 | Y7 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
46 | F07100 | CCQ WORKFILE | 4 | F7 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
47 | F0716701 | Employee Assignment T/E Template Information | 4 | EA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
48 | F0716709 | Employee Assignment T/E Template Info History | 4 | EA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
49 | F0717 | ROE Summary History | 40 | JF | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
50 | F071861 | Stub Detail Piece Rate History File | 6 | Y8 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
51 | F0719 | DBA Transaction Detail History | 23 | Y$ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
52 | F0729 | Employee DBA Override Instructions | 71 | Y9 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
53 | F073521 | Stub Detail Piece Rate File | 6 | Y2 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
54 | F07355 | Pre-Payroll Error File | 21 | Y5 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
55 | F074001 | New Hire Reporting Workfile - OneWorld Only | 81 | NH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
56 | F07880 | SUI Magnetic Media Workfile | 41 | YW | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
57 | F07UI200 | Timecard History Work File | 46 | TH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08: Human Resources |
58 | F0800601 | Organizational Business Unit/Job Cross-Reference | 2 | JC | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
59 | F0800605 | Job Type/Step Competencies | 1 | JC | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
60 | F0800609 | Gap Analysis Snapshot | 8 | YI | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
61 | F0800610 | Competencies in Structure and Job | 2 | JC | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
62 | F0800612 | User Defined Job Competency Description Reference | 9 | JC | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
63 | F08006WF | Job Competency Default Overrides Work File | 7 | JC | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
64 | F08092 | Human Resources General Description-User Def Codes | 4 | JZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
65 | F08093 | Human Resources General Description - Narration | 4 | JY | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
66 | F081161 | ACA Employee Eligibility | 26 | AD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
67 | F0811619 | ACA Employee Eligibility Archive | 26 | AD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
68 | F082003 | Grade/Step Progression Detail File | 5 | YW | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
69 | F083305 | Mail Merge Header/Detail | 22 | MM | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
70 | F087101 | Default Setup Tasks | 1 | DT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
71 | F087711 | CBPA Appraisal Header | 15 | XJ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
72 | F08JDWF1 | Job Description Changes Integration Work File | 7 | JC | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
73 | F08JDWF2 | Job Description History Integration Work File | 3 | JH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08AD: ADP Integration |
74 | F051371 | ADP Employee DBA Instructions | 63 | AD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
75 | F051372 | ADP Employee Job Master Information | 8 | AD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08B: Benefits Administration |
76 | F0833WF | Benefit Statement Work file | 19 | WF | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08H: Health and Safety |
77 | F08601 | Injury/Illness Case Master | 5 | HL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08P: Position Control |
78 | F08001 | Job information | 2 | JM | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
79 | F08005 | Business Unit/ Job Id. X-Ref | 2 | JV | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
80 | F08101 | Position Master | 14 | HP | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
81 | F08101P | Purge - Position Master | 14 | HP | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
82 | F08111 | Position Budget Detail | 8 | HQ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
83 | F08111P | Purge - Position Budget Detail | 8 | HQ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08R: Recruitment Management - (Appl. Track. & Req.) |
84 | F08102 | Requisition Information | 13 | HN | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
85 | F08401 | Applicant Master | 7 | HA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
86 | F08401WF | Applicant Work File | 8 | XN | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08U: PeopleSoft HR US |
87 | F08910 | COBRA Qualified Beneficiary File | 29 | J1 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
88 | F08920 | COBRA Coverage | 8 | JS | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP08W: Wage and Salary |
89 | F08201 | Salary Review Workfile | 15 | HR | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
90 | F08830WF | Compensation Root Work Table | 30 | YN | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP09: General Accounting |
91 | F0911P | Purge - Account Ledger | 90 | GL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
92 | F0911Z1 | Journal Entry Transactions - Batch File | 107 | VN | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
93 | F0911Z4 | F0911 Interoperability Table | 112 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
94 | F09123 | Advanced Variable Numerator | 58 | VN | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
95 | F09UI015 | Indexed Computations Multi-Tiered Entries | 90 | GL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
96 | F52G11 | Burdening Detail Ledger | 31 | BD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
97 | F52G11WF | Temporary Burdened Detail Ledger Workfile | 31 | BW | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP12: Fixed Assets |
98 | F1201 | Asset Master File | 83 | FA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
99 | F1201P | Asset Master Purge Table | 83 | FA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
100 | F1201Z1 | Unedited Asset Master Transactions | 94 | FA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP13R: Resource Assignments |
101 | F48311 | Resource Assignments | 13 | RA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
102 | F48311S | Purge - Resource Assignments | 13 | RA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP17: Customer Service Management |
103 | F3112Z2 | Warranty Claim/Supplier Recovery processing | 34 | WL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
104 | F4801TZ2 | Warranty Claim/Supplier Recovery processing | 60 | WQ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP18: Timecard Automation |
105 | F186301 | Timecard Templates | 24 | TT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
106 | F186602 | Labor Rules Tag File | 54 | TF | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP30: Product Data Management |
107 | F300311 | Lean Multi-Level Routing Detail File | 31 | EH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
108 | F3003Z1 | Routing Transactions File | 48 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP31: Shop Floor Control |
109 | F3112 | Work Order Routing | 21 | WL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
110 | F3112S | Purge Shop Floor Control Routing Instructions | 21 | WL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
111 | F3112Z1 | Outbound Work Order Routings | 34 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP40: Inventory/OP Base |
112 | F3003 | Routing Master File | 35 | IR | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP41F: Apparel Management |
113 | FCW68 | Style Work Order Routings | 22 | WL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
114 | FCW93 | Copy to Outsource Operations for Style Items | 3 | ST | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP42: Sales Management |
115 | F42800G1 | Sales Update G Batch Detail Workfile | 76 | DG | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP43: Procurement |
116 | F4311 | Purchase Order Detail File | 223 | PD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
117 | F4311Z | Purchase Order Generator File | 249 | PW | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
118 | F4311Z1 | Purchase Order Detail Unedited Transaction Table | 233 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
119 | F43121 | Purchase Order Receiver File | 155 | PR | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
120 | F43121Z | Receiver workfile | 198 | PW | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
121 | F43121Z1 | Receipts Unedited Transaction Table | 200 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
122 | F4314Z | Voucher Match Selection File | 209 | PN | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
123 | F4316 | Purchase Order Multiple Account File | 57 | P3 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
124 | F43199 | P.O. Detail Ledger File - Flexible Version | 225 | OL | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
125 | F43UI50D | PO Print Detail Work File | 73 | PW | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP43A: Purchase Order Receipt/Routing |
126 | F43126 | Purchase Order Receiver Multiple Account | 58 | P4 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP47: Electronic Commerce |
127 | F47012 | EDI Purchase Order Detail - Inbound | 257 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
128 | F47017 | EDI Purchase Order Detail - Outbound | 226 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
129 | F47042 | EDI Invoice Detail - Inbound | 105 | SZ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP48: Work Order Processing |
130 | F4801ST | Purge - Work Order Master Tag File | 47 | WA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
131 | F4801T | Work Order Master Tag File | 47 | WA | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP48S: Service Billing |
132 | F48096 | Billing Rate / Mark up Table | 9 | WQ | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
133 | F4812 | Billing Detail Workfile | 34 | WD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
134 | F4812H | Billing Workfile History | 34 | WD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
135 | F4812HS | Billing Workfile History Purged Save | 34 | WD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
136 | F48S0618 | Payroll Reclassification Workfile | 43 | YT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
137 | F48S910 | Billing Detail Journal Workfile | 48 | W2 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
138 | F48S911 | Summarized Journal Workfile | 39 | W3 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
139 | F48SUI01 | Billing Detail Print Workfile | 34 | WD | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP49: Transportation Management |
140 | F49004 | Mode of Transport Constants | 3 | CT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
141 | F49040 | Vehicle Staff (Conversion from World File) | 3 | VS | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
142 | F49041 | Depot/Vehicle Staff | 6 | VS | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
143 | F49614 | Load Staff | 3 | TS | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP52: Contract Billing |
144 | F5212 | T and M, Unit Price and Lumpsum Cross Reference Accounts | 13 | G5 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP52G: Proj & Gov Contract Accounting |
145 | F52G20 | Contract Specific Labor Categories | 5 | LC | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
146 | F52G20W | Labor Category Work File | 7 | LW | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
147 | F52G21 | Contract Specific Labor Category Cross Reference | 5 | LR | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
148 | F52G90 | Invoice Printing Work Table | 39 | WT | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP54HS: Health & Safety Incident Mgt |
149 | F54HS02 | Incident People | 22 | S2 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
150 | F54HS02M | Incident People Change History | 25 | I2 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP75Z: New Zealand |
151 | F75Z0008 | New Zealand Special Rates | 5 | Z8 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP77: Payroll (Canadian) |
152 | F07183 | Commission History Detail File | 11 | ZB | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOP89: Conversion Programs |
153 | F07186T | Piece Rate History File | 6 | Y8 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
154 | F07352T | Piece Rate Stub Detail Tag File | 6 | Y2 | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOPF30L: DFM Line Design |
155 | FF30L930 | DFM Routings | 36 | LR | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
TOPF31: Lean Transactions |
156 | FF31112 | Routing Transaction Table | 11 | EH | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |
157 | FF31112S | Purge - Routing Transaction Table | 11 | ET | JBCD | Job Type (Craft) Code | String | UDC | 6 | 0 |