GP_GCTL_DTL

#	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
3	EMPL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Payroll Status A=Active D=Deceased L=Leave of Absence P=Leave With Pay Q=Retired With Pay R=Retired S=Suspended T=Terminated U=Terminated With Pay V=Terminated Pension Pay Out W=Short Work Break X=Retired-Pension Administration
4	ACTION	Character(3)	VARCHAR2(3) NOT NULL	Action Prompt Table: ACTION_TBL
5	ACTION_REASON	Character(3)	VARCHAR2(3) NOT NULL	Reason Code Prompt Table: ACTN_REASON_TBL
6	SEG_STATUS	Character(2)	VARCHAR2(2) NOT NULL	Segment Status 00=Active in Segment 01=Inactive in Segment
7	FREQUENCY_TAG	Character(10)	VARCHAR2(10) NOT NULL	Frequency tag .. used for generation control Prompt Table: GP_GCTL_FREQ
8	PIN_FRML_NUM	Number(8,0)	INTEGER NOT NULL	Element number field
9	RUN_TYPE	Character(10)	VARCHAR2(10) NOT NULL	Run Type Name Prompt Table: GP_RUN_TYPE
10	GCTL_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Generation Control Type AR=HR Action / Reason FM=Formula FQ=Frequency RT=Run Type SS=Segment Status ST=HR Status
11	EMPL_STATUS_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Employee Status Condition Option A=All Job Records in Segment L=Last Job Record Default Value: A