GP_PKG_IDPIN_NUMEFFDTA=Active
I=Inactive
E=End Date of Last Occurrence
F=Start Date of 1st Occurrence
D=Days
M=Months
W=Weeks
A=Allow Negative Balance
O=Take with Other Absence
U=Take as Unpaid Time
0=No Duplicates Allowed
1=Duplicates Ok
GP_PKG_AT1_AD(SQL Table) |
Index Back |
|---|---|
Absence Take Rules DfnSetup/Maintain Absence Take Elements - Main Record. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GP_PKG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Field used for element packaging |
| 2 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | ABS_TYPE_OPTN | Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 6 | TAKE_CONFIG1 | Character(10) | VARCHAR2(10) NOT NULL | Field reserved for custom attribution to an Absence Take |
| 7 | TAKE_CONFIG2 | Character(10) | VARCHAR2(10) NOT NULL | Field reserved for custom attribution to an Absence Take |
| 8 | TAKE_CONFIG3 | Character(10) | VARCHAR2(10) NOT NULL | Field reserved for custom attribution to an Absence Take |
| 9 | TAKE_CONFIG4 | Character(10) | VARCHAR2(10) NOT NULL | Field reserved for custom attribution to an Absence Take |
| 10 | MGR_APPR_REQ_IND | Character(1) | VARCHAR2(1) NOT NULL | Manager Approval Required |
| 11 | MULTIPLE_INST_IND | Character(1) | VARCHAR2(1) NOT NULL | Multiple Instances |
| 12 | PIN_BAL_OFFSET_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 13 | ENTRY_TYPE_FROM | Character(3) | VARCHAR2(3) NOT NULL | Entry Type for Date From Element |
| 14 | DATE_FROM | Date(10) | DATE | Date From |
| 15 | PIN_DATE_FROM_NUM | Number(8,0) | INTEGER NOT NULL | Previous Period Date From Element |
| 16 | ENTRY_TYPE_TO | Character(3) | VARCHAR2(3) NOT NULL | Entry Type for Date To Element |
| 17 | DATE_TO | Date(10) | DATE | Previous Period Date To |
| 18 | PIN_DATE_TO_NUM | Number(8,0) | INTEGER NOT NULL | Previous Period To Date Element |
| 19 | PIN_LINKED_TO_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 20 | PIN_LINK_COND_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 21 | PIN_DAY_FM_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 22 | ENTRY_TYPE_ELEM | Character(3) | VARCHAR2(3) NOT NULL | entry type element |
| 23 | ELIG_PRD_IND | Character(1) | VARCHAR2(1) NOT NULL | Eligibility |
| 24 | ELIG_DATE | Date(10) | DATE | Eligiblity Date |
| 25 | PIN_ELIG_DATE_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 26 | ENTRY_TYPE_ELEM2 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
| 27 | MIN_PRD_IND | Character(1) | VARCHAR2(1) NOT NULL | Minimum Absence |
| 28 | PIN_MIN_PRD_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 29 | MIN_PRD_VAL | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Minimum Period Value |
| 30 | ENTRY_TYPE_ELEM3 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
| 31 | WAIT_PRD_IND | Character(1) | VARCHAR2(1) NOT NULL | Wait Per Absence |
| 32 | PIN_WAIT_PRD_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 33 | WAIT_PRD_VAL | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Wait Period Value |
| 34 | PIN_WAIT_CNT_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 35 | ENTRY_TYPE_ELEM4 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
| 36 | LINK_PRD_IND | Character(1) | VARCHAR2(1) NOT NULL | Link Absence |
| 37 | PIN_LINK_PRD_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 38 | LINK_PRD_VAL | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Link Period Value |
| 39 | LINK_FROM_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Starting From
E=End Date of Last Occurrence F=Start Date of 1st Occurrence |
| 40 | LINK_PRD_UNIT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Linked Within Absence Unit Opt
D=Days M=Months W=Weeks |
| 41 | SAME_ABSENCE_IND | Character(1) | VARCHAR2(1) NOT NULL | By Original Begin Date |
| 42 | ENTRY_TYPE_ELEM5 | Character(3) | VARCHAR2(3) NOT NULL | Entry (element) type field |
| 43 | NEG_BAL_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Negative Balance Option
A=Allow Negative Balance O=Take with Other Absence U=Take as Unpaid Time |
| 44 | NEG_LMT_VAL | Signed Number(8,2) | DECIMAL(6,2) NOT NULL | Negative Limit Value |
| 45 | PIN_NEG_ABS_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 46 | PIN_NEG_LMT_NUM | Number(8,0) | INTEGER NOT NULL | Element number field |
| 47 | EVT_DUP_IND | Character(1) | VARCHAR2(1) NOT NULL |
allow overlapping instances of absence
0=No Duplicates Allowed 1=Duplicates Ok |
| 48 | EVT_PRIORITY | Number(3,0) | SMALLINT NOT NULL | Event Priority |
| 49 | PIN_FCST_NUM | Number(8,0) | INTEGER NOT NULL | This field is used on the GP_ABS_TAKE definition to identify the forecast element to be resolved during forecasting for the event associated with that take. |
| 50 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |