GP_AUD_DUR_FRML

(SQL Table)
Index Back

Duration Definition

Duration rule definitions - Main record.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
3 CAL_RUN_ID Character(18) VARCHAR2(18) NOT NULL Calendar Run Id
4 CAL_ID Character(18) VARCHAR2(18) NOT NULL calendar id
5 AUDIT_SORT_KEY Number(8,0) INTEGER NOT NULL Chain Sort Key
6 PIN_CHAIN_LVL_NUM Number(4,0) SMALLINT NOT NULL Depth Level of Element Resolution in an Audit Chain
7 PIN_CHAIN_SEQ_NUM Number(4,0) SMALLINT NOT NULL Processing Sequence of an Element in an Audit Chain
8 PIN_CHAIN_RSLT_NUM Number(4,0) SMALLINT NOT NULL Resolution Sequence of an Element in an Audit Chain
9 PIN_FRML_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_FM2_VW

10 GP_AUD_CHAR_NM3 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
11 GP_AUD_LINK3 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics
12 GP_AUD_CHAR_VAL3 Character(30) VARCHAR2(30) NOT NULL used in payroll analytics