GP_NRP_ABSOV_VW(SQL View) |
Index Back |
|---|---|
Absence Override Defn ViewAbsence Override Definition - Packaging View |
| SELECT EMPLID ,EMPL_RCD ,PIN_NUM + 50000000 ,BGN_DT ,END_DT ,ENTRY_TYPE_ELEM ,ENTRY_TYPE_ENTL ,ENT_VAL_NUM ,PIN_ENT_NUM + 50000000 ,PYE_APPL_IND ,ENT_FREQ_OPTN ,FREQUENCY_ID ,GCTL_CND_OPTN ,PIN_GCTL_NUM + 50000000 FROM PS_GP_ABS_OVRD |
| # | 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 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL |
PIN Number
Prompt Table: %GP_EDIT_FLD1 |
| 4 | BGN_DT |
Date(10) | DATE |
Begin Date
Default Value: %date |
| 5 | END_DT | Date(10) | DATE | end date |
| 6 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL |
entry type element
Prompt Table: GP_ENT_ABS6_VW |
| 7 | ENTRY_TYPE_ENTL | Character(3) | VARCHAR2(3) NOT NULL |
Entry (element) type field
Prompt Table: GP_ENT_ABS2_VW |
| 8 | ENT_VAL_NUM | Signed Number(12,6) | DECIMAL(10,6) NOT NULL | Entitlement Unit |
| 9 | PIN_ENT_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: %GP_EDIT_FLD2 |
| 10 | PYE_APPL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Payee Apply Override Indicator
Y/N Table Edit Default Value: Y |
| 11 | ENT_FREQ_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Entitlement Freq Option
S=Calculate Per Other Frequency U=Calculate Per Pay Period |
| 12 | 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 |
| 13 | GCTL_CND_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Generation Control Options
E=Use Element Generation Control N=No Generation Control S=Specified Generation Control Default Value: E |
| 14 | PIN_GCTL_NUM | Number(8,0) | INTEGER NOT NULL |
Generation Control Number
Prompt Table: GP_PIN_GC0_VW |