GPCN_PHFSI_SET1

(SQL Table)
Index Back

Specify Contributions Master

Specify Contributions Master Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 GPCN_HOUSE_IND Character(1) VARCHAR2(1) NOT NULL PHF Indicator

Y/N Table Edit

Default Value: N

4 GPCN_HOUSE_VOL_IND Character(1) VARCHAR2(1) NOT NULL PHF VOL Indicator

Y/N Table Edit

Default Value: N

5 GPCN_INJURY_IND Character(1) VARCHAR2(1) NOT NULL Injury SI Indicator

Y/N Table Edit

Default Value: N

6 GPCN_MATERNITY_IND Character(1) VARCHAR2(1) NOT NULL Maternity Indicator

Y/N Table Edit

Default Value: N

7 GPCN_MEDICAL_IND Character(1) VARCHAR2(1) NOT NULL Medical SI Indicator

Y/N Table Edit

Default Value: N

8 GPCN_PENSION_IND Character(1) VARCHAR2(1) NOT NULL Pension SI Indicator

Y/N Table Edit

Default Value: N

9 GPCN_SUP_MED_IND Character(1) VARCHAR2(1) NOT NULL Supplementary Medical Indicator

Y/N Table Edit

Default Value: N

10 GPCN_UNEMPLOY_IND Character(1) VARCHAR2(1) NOT NULL Unemployment Indicator

Y/N Table Edit

Default Value: N