PUBNODEPRCSINSTANCEXREF_NUMPAY_SYSTEMGP=Global Payroll
NA=North American Payroll
DIST_ACTION_TYPEA=Add
U=Update
C=Cost
R=Rate
PYTL2_STG_SUB(SQL Table) |
Index Back |
|---|---|
Payroll Cost information |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PUBNODE |
Character(30) | VARCHAR2(30) NOT NULL | Application Messaging Publication Node. This refers to the Node that the Application Message Instance was published from. |
| 2 | PRCSINSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 3 | XREF_NUM |
Number(15,0) | DECIMAL(15) NOT NULL | T&L Xref Num |
| 4 | PAY_SYSTEM |
Character(4) | VARCHAR2(4) NOT NULL |
Payroll System
GP=Global Payroll NA=North American Payroll |
| 5 | DIST_ACTION_TYPE |
Character(1) | VARCHAR2(1) NOT NULL |
Action Type for Labor Distribution. An action type of add will add the amount given to the amount in Payable Time. An action type of update will replace the amound in Payable Time with the amount given.
A=Add U=Update |
| 6 | RATE_COST_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
The flag is used for labor distribution. It indicatates whether a rate or a cost should be used for labor distribution.
C=Cost R=Rate |
| 7 | XREF_COST | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Actual cost of payroll entry |
| 8 | RATE | Signed Number(20,6) | DECIMAL(18,6) NOT NULL | Rate |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | STATUS_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Status Flag |