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=Payroll for North America
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