GP_GCTL_FM_VW

(SQL View)
 Index Back

Generation Control - Formula

Generation Control - Formula

SELECT PIN_NUM , EFFDT , EMPL_STATUS , ACTION , ACTION_REASON , SEG_STATUS , FREQUENCY_TAG , PIN_FRML_NUM , RUN_TYPE , GCTL_TYPE , EMPL_STATUS_OPTN FROM PS_GP_GCTL_DTL WHERE GCTL_TYPE = 'FM'

# 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

Prompt Table: GP_PIN_FM4_VW

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

Default Value: FM

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