GPSC_ELM_ABS_EN

(SQL View)
 Index Back

Absence Entitlement Rules Dfn

Absence Entitlement rule definitions - Main record.

SELECT PIN_NUM , EFFDT , EFF_STATUS , ENTRY_TYPE_ENTL , ENT_VAL_NUM , PIN_ENT_NUM , ENT_FREQ_OPTN , ENT_PER_ABS_IND , PIN_COND_ENT_NUM , FREQUENCY_ID , ENTRY_TYPE_UNIT , RND_OPTN_ENTL , PIN_RND_ENTL_NUM , PRORATION_OPTN , PIN_PRO_NUM , PIN_ADJ_UNIT_NUM , ENTRY_TYPE_PAYOFF , PIN_PAY_UNIT_NUM , PIN_PAY_ER_NUM , PIN_GCTL_NUM , PIN_GCTL2_NUM , GP_VERSION FROM PS_GP_ABS_ENTL WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , EFF_STATUS , ENTRY_TYPE_ENTL , ENT_VAL_NUM , PIN_ENT_NUM , ENT_FREQ_OPTN , ENT_PER_ABS_IND , PIN_COND_ENT_NUM , FREQUENCY_ID , ENTRY_TYPE_UNIT , RND_OPTN_ENTL , PIN_RND_ENTL_NUM , PRORATION_OPTN , PIN_PRO_NUM , PIN_ADJ_UNIT_NUM , ENTRY_TYPE_PAYOFF , PIN_PAY_UNIT_NUM , PIN_PAY_ER_NUM , PIN_GCTL_NUM , PIN_GCTL2_NUM , GP_VERSION FROM PS_GPSC_RM_ABS_ENT WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# 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_ENTL Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_ABS2_VW

5 ENT_VAL_NUM Signed Number(12,6) DECIMAL(10,6) NOT NULL Entitlement Unit
6 PIN_ENT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD1

7 ENT_FREQ_OPTN Character(1) VARCHAR2(1) NOT NULL Entitlement Freq Option
S=Calculate Per Other Frequency
U=Calculate Per Pay Period
8 ENT_PER_ABS_IND Character(1) VARCHAR2(1) NOT NULL Per Absence (not Freq. based)

Y/N Table Edit

9 PIN_COND_ENT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_FRMG_VW

10 FREQUENCY_ID Character(5) VARCHAR2(5) NOT NULL Defines a frequency and a set of parameters used for frequency conversion. Typically, these frequencies reflect how often an event occurs. Some examples are compensation frequency and pay frequency.

Prompt Table: FREQUENCY_TBL

11 ENTRY_TYPE_UNIT Character(3) VARCHAR2(3) NOT NULL entry type unit

Prompt Table: GP_ENT_ABS5_VW

12 RND_OPTN_ENTL Character(2) VARCHAR2(2) NOT NULL Rounding Rule Option for Entitlement element
NR=No Rounding
PG=Use Pay Group Rounding
SP=Use Specified Rounding
13 PIN_RND_ENTL_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_RR0_VW

14 PRORATION_OPTN Character(2) VARCHAR2(2) NOT NULL Proration Option
NP=No Proration
PG=Use Pay Group Proration Rule
SP=Use Specified Proration Rule
15 PIN_PRO_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_PO0_VW

16 PIN_ADJ_UNIT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD2

17 ENTRY_TYPE_PAYOFF Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

Prompt Table: GP_ENT_ABS5_VW

18 PIN_PAY_UNIT_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: %GP_EDIT_FLD3

19 PIN_PAY_ER_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_ER_VW

20 PIN_GCTL_NUM Number(8,0) INTEGER NOT NULL Generation Control Number

Prompt Table: GP_PIN_GC0_VW

21 PIN_GCTL2_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_GC0_VW

22 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.