GP_CAL_RUN_HST

#	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	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
5	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
6	USE_AS_TMPLT_IND	Character(1)	VARCHAR2(1) NOT NULL	Use this Cal Group ID as a Template during absence forecasting. Y/N Table Edit Default Value: N
7	PROCESS_RETRO_IND	Character(1)	VARCHAR2(1) NOT NULL	Process Retro Indicator Y/N Table Edit Default Value: N
8	PROCESS_STRM_IND	Character(1)	VARCHAR2(1) NOT NULL	Process by stream Y/N Table Edit Default Value: N
9	RUN_OPEN_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N Indicates that processing has been initiated for given run (calendar group). Y/N Table Edit Default Value: N
10	RUN_OPEN_TS	DateTime(26)	TIMESTAMP	Records the time when processing was first initiated for a given calendar group
11	RUN_FINALIZED_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalized Run Y/N Table Edit Default Value: N
12	RUN_FINALIZED_TS	DateTime(26)	TIMESTAMP	Finalized Timestamp
13	PMT_SENT_IND	Character(1)	VARCHAR2(1) NOT NULL	Payment Sent Indicator. Used in GP to indicate on a Cal Run basis when the payroll payments have been sent to the bank(s). Y/N Table Edit Default Value: N
14	GL_SENT_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N Indicates whether GL transactions are sent for a given payroll run (calendar group). Y/N Table Edit Default Value: N
15	TL_SENT_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N indicator for whether the job to send cost back to TL has been run for a given calendar group Y/N Table Edit Default Value: N
16	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY_VW
17	PRC_NUM	Number(5,0)	INTEGER NOT NULL	Process Number
18	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N