PY_LDTL_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_SYSTEM	Character(4)	VARCHAR2(4) NOT NULL	Payroll System GP=Global Payroll NA=North American Payroll
2	PAYROLL_REQ_NUM	Number(6,0)	INTEGER NOT NULL	Last payroll request number.
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	REQ_SRC	Character(1)	VARCHAR2(1) NOT NULL	Request Source C=Pay Calculation F=Final Check O=On-Line Check U=User
5	PY_LDTL_DATETIME	DateTime(26)	TIMESTAMP	Load Process Date & Time
6	RUN_ID	Character(10)	VARCHAR2(10) NOT NULL	Pay Run ID Prompt Table: PAY_RUN_TBL
7	PROCESS_ON_OFF	Character(1)	VARCHAR2(1) NOT NULL	Process On-Cycle or Off-Cycle F=Process Off-Cycle Checks O=Process On-Cycle Checks
8	OK_TO_PAY	Character(1)	VARCHAR2(1) NOT NULL	OK to Pay
9	REPEAT_REQ_CD	Character(1)	VARCHAR2(1) NOT NULL	Refresh Request A=All Between Range D=By Range of Dates N=None R=By Request Number T=By Last Request
10	PY_LDTL_PRCS_OPT	Character(1)	VARCHAR2(1) NOT NULL	Time and Labor Load Processing Option A=Load All Time F=Load Filtered Time P=Load Prior Period Time
11	PY_LDTL_SEPCHK	Character(1)	VARCHAR2(1) NOT NULL	Load Time to Paysheets on Separate Checks Y/N Table Edit
12	FROMDATE	Date(10)	DATE	From Date
13	THRUDATE	Date(10)	DATE	End Date