GP_CAL_RUN_STRM (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_CAL_RUN_STRM

(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 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id

2 STRM_NUM Number(4,0) SMALLINT NOT NULL Stream Number

3 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

4 STRM_IDNT_TS DateTime(26) TIMESTAMP Stream Identification

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	STRM_NUM	Number(4,0)	SMALLINT NOT NULL	Stream Number
3	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
4	STRM_IDNT_TS	DateTime(26)	TIMESTAMP	Stream Identification