GP_AUD_PROR_DTL

(SQL Table)
 Index Back

Proration Rule Definition.

Proration rule definitions - Main Record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 EFFDT Date(10) DATE NOT NULL Effective Date
3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 ENTRY_TYPE_ELEM Character(3) VARCHAR2(3) NOT NULL entry type element

Prompt Table: GP_ENT_PRO_VW

5 PIN_NUMERATOR_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD1

6 GP_AUD_CHAR_NM1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
7 GP_AUD_LINK1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
8 GP_AUD_CHAR_VAL1 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
9 ENTRY_TYPE_ELEM2 Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_PRO_VW

10 PIN_DENOMIN_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD2

11 GP_AUD_CHAR_NM2 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
12 GP_AUD_LINK2 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
13 GP_AUD_CHAR_VAL2 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
14 DENOM_USES_NUMER Character(1) VARCHAR2(1) NOT NULL Denominator Schedule
N=Use All Schedules in Segment
Y=Use Last Schedule in Segment
15 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.
16 GROUPBOX_PR Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
17 GROUPBOX_PR2 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.
18 GROUPBOX_PR3 Character(1) VARCHAR2(1) NOT NULL Generic groupbox field.