GP_CL_RN_ST_HST (SQL Table)	Index Back
GP Calendar Group stream child table of GP CAL RUN tracking the progress of each subset of employees through absence and payroll process (1 or many for a given calendar group

GP_CL_RN_ST_HST

(SQL Table)

GP Calendar Group stream

child table of GP CAL RUN tracking the progress of each subset of employees through absence and payroll process (1 or many for a given calendar group

# 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 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

5 STRM_IDNT_IND Character(1) VARCHAR2(1) NOT NULL Y/N Indicator showing whether a given stream (subset) of a Calendar Group has been Identified for processing
Y/N Table Edit
Default Value: N

6 STRM_IDNT_TS DateTime(26) TIMESTAMP Stream Identification

#	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	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
5	STRM_IDNT_IND	Character(1)	VARCHAR2(1) NOT NULL	Y/N Indicator showing whether a given stream (subset) of a Calendar Group has been Identified for processing Y/N Table Edit Default Value: N
6	STRM_IDNT_TS	DateTime(26)	TIMESTAMP	Stream Identification