GPSC_RM_GCTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PIN_NUM	Number(8,0)	INTEGER NOT NULL	PIN Number Default Value: 99999999
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %Date
3	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
4	GCTL_OPTN_EMPLSTAT	Character(1)	VARCHAR2(1) NOT NULL	Generation Control Employee Status Indicator E=Exclude I=Include Default Value: I
5	GCTL_OPTN_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Generation Control Action Indicator E=Exclude I=Include Default Value: I
6	GCTL_OPTN_SEGSTAT	Character(1)	VARCHAR2(1) NOT NULL	Generation Control Segment Indicator E=Exclude I=Include Default Value: I
7	GCTL_OPTN_FREQ	Character(1)	VARCHAR2(1) NOT NULL	Generation Control Frequency Indicator E=Exclude I=Include Default Value: I
8	GCTL_OPTN_FRML	Character(1)	VARCHAR2(1) NOT NULL	Generation Control Formula Indicator E=Exclude I=Include Default Value: I
9	GCTL_OPTN_RUN_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Generation Control Run Type Indicator E=Exclude I=Include Default Value: I
10	LAST_DAY_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Use Last Day Option N=No Y=Yes Y/N Table Edit
11	GP_VERSION	Character(18)	VARCHAR2(18) NOT NULL	Stores element version.