GP_CAL_RUN

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description Default Value: GP_CAL_RUN.DESCR
4	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
5	PROCESS_RETRO_IND	Character(1)	VARCHAR2(1) NOT NULL	Process Retro Indicator Y/N Table Edit Default Value: N
6	PROCESS_STRM_IND	Character(1)	VARCHAR2(1) NOT NULL	Process by stream Y/N Table Edit Default Value: N
7	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
8	RUN_OPEN_TS	DateTime(26)	TIMESTAMP	Records the time when processing was first initiated for a given calendar group
9	RUN_FINALIZED_IND	Character(1)	VARCHAR2(1) NOT NULL	Finalized Run Y/N Table Edit Default Value: N
10	RUN_FINALIZED_TS	DateTime(26)	TIMESTAMP	Finalized Timestamp
11	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
12	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
13	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
14	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: GP_COUNTRY_VW
15	PRC_NUM	Number(5,0)	INTEGER NOT NULL	Process Number
16	OFF_CYCLE	Character(1)	VARCHAR2(1) NOT NULL	Off Cycle ? Y/N Table Edit Default Value: N