PSARCH_IDPSARCH_BATCHNUMPAY_SYSTEMGP=Global Payroll
NA=Payroll for North America
SEQ_NBRXREF_NUMTL_XREF_TBL_HST(SQL Table) |
Index Back |
|---|---|
Archive Rec - Xref TableArchive Record for Xref Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | PSARCH_BATCHNUM |
Number(30,0) | DECIMAL(30) NOT NULL | Archive Batch Number |
| 3 | PAY_SYSTEM |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=Payroll for North America |
| 4 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 5 | XREF_NUM |
Number(15,0) | DECIMAL(15) NOT NULL | T&L Xref Num |
| 6 | DISTRIB_PCT | Signed Number(18,10) | DECIMAL(16,10) NOT NULL | Overall Distribution Percent |
| 7 | TL_QUANTITY | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | This field represents the measure of Work in hrs,amount etc., |