GPCH_SI_SC2_SCK (SQL Table)	Index Back
Data for Sick Pay CHE with Years-of-service and weeks to be paid

GPCH_SI_SC2_SCK

(SQL Table)

Data for Sick Pay CHE

with Years-of-service and weeks to be paid

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 GPCH_SI_SCALE_CD Number(1,0) SMALLINT NOT NULL Scale Code
Prompt Table: GPCH_SI_SCL_CD

2 EFFDT Date(10) DATE NOT NULL Effective Date

3 GPCH_SI_YRS_SRVC Number(2,0) SMALLINT NOT NULL Service Years

4 GPCH_SI_WK_SICK Number(2,0) SMALLINT NOT NULL Salary Continuance in Weeks

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	GPCH_SI_SCALE_CD	Number(1,0)	SMALLINT NOT NULL	Scale Code Prompt Table: GPCH_SI_SCL_CD
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date
3	GPCH_SI_YRS_SRVC	Number(2,0)	SMALLINT NOT NULL	Service Years
4	GPCH_SI_WK_SICK	Number(2,0)	SMALLINT NOT NULL	Salary Continuance in Weeks