GP_CAL_OFF_VW (SQL View)	Index Back
view of GP CAL RUN OFF used for presentation of GP CAL RUN OFF associated with the calendar group on pages like GP PMT PREP SBP and others were calendar groups are referenced for info only

GP_CAL_OFF_VW

(SQL View)

view of GP CAL RUN OFF

used for presentation of GP CAL RUN OFF associated with the calendar group on pages like GP PMT PREP SBP and others were calendar groups are referenced for info only

SELECT CAL_RUN_ID , CAL_SEQ_NUM , GP_PAYGROUP , CAL_PRD_ID , OFF_CYCLE_ID FROM PS_GP_CAL_RUN_OFF

Parent record: 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 CAL_SEQ_NUM Number(8,0) INTEGER NOT NULL Calendar Sequence Number

3 GP_PAYGROUP Character(10) VARCHAR2(10) NOT NULL Global Payroll pay group

4 CAL_PRD_ID Character(10) VARCHAR2(10) NOT NULL Calendar Period ID

5 OFF_CYCLE_ID Character(18) VARCHAR2(18) NOT NULL Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CAL_RUN_ID	Character(18)	VARCHAR2(18) NOT NULL	Calendar Run Id
2	CAL_SEQ_NUM	Number(8,0)	INTEGER NOT NULL	Calendar Sequence Number
3	GP_PAYGROUP	Character(10)	VARCHAR2(10) NOT NULL	Global Payroll pay group
4	CAL_PRD_ID	Character(10)	VARCHAR2(10) NOT NULL	Calendar Period ID
5	OFF_CYCLE_ID	Character(18)	VARCHAR2(18) NOT NULL	Off-Cycle Group or Request ID. ID field used to identify, group and manage a set of payments requested to be made as Off-cycle payments