GP_AUD_GC_DTL

(SQL Table)
 Index Back

Generation Control Detail Rec

Generation Control Detail Rec

# 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 GCTL_OPTN_EMPLSTAT Character(1) VARCHAR2(1) NOT NULL Generation Control Employee Status Indicator
E=Exclude
I=Include
12 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

13 GCTL_OPTN_ACTION Character(1) VARCHAR2(1) NOT NULL Generation Control Action Indicator
E=Exclude
I=Include
14 GCTL_OPTN_SEGSTAT Character(1) VARCHAR2(1) NOT NULL Generation Control Segment Indicator
E=Exclude
I=Include
15 GCTL_OPTN_FREQ Character(1) VARCHAR2(1) NOT NULL Generation Control Frequency Indicator
E=Exclude
I=Include
16 GCTL_OPTN_FRML Character(1) VARCHAR2(1) NOT NULL Generation Control Formula Indicator
E=Exclude
I=Include
17 GCTL_OPTN_RUN_TYPE Character(1) VARCHAR2(1) NOT NULL Generation Control Run Type Indicator
E=Exclude
I=Include
18 LAST_DAY_OPTN Character(1) VARCHAR2(1) NOT NULL Use Last Day Option
N=No
Y=Yes
19 GROUPBOX_GC Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
20 GROUPBOX_GC2 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
21 GROUPBOX_GC3 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
22 GROUPBOX_GC4 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
23 GROUPBOX_GC5 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
24 GROUPBOX_GC6 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
25 GROUPBOX_GC7 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
26 GROUPBOX_GC8 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.