TL_PUBDT_WRK

(SQL Table)
Index Back

TL Accounting Dt Rec

This record is used to derive accounting date. This is an input table to PSPTFUND cobol process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
3 PAYGROUP Character(3) VARCHAR2(3) NOT NULL Pay Group
4 PAY_END_DT Date(10) DATE Pay Period End Date
5 COMMIT_ACCTG_FLG Character(1) VARCHAR2(1) NOT NULL Commitment Accounting
6 ACCOUNTING_DT Date(10) DATE Accounting Date
7 PAY_BEGIN_DT Date(10) DATE Pay Period Begin Date
8 END_DT Date(10) DATE end date