GP_AUD_DUR_DTL(SQL Table) |
Index Back |
|---|---|
Duration DefinitionDuration 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 | Effective Date |
| 3 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 4 | ENTRY_TYPE_FROM | Character(3) | VARCHAR2(3) NOT NULL |
Entry Type for Date From Element
Prompt Table: GP_ENT_DATE_VW |
| 5 | DATE_FROM | Date(10) | DATE | Date From |
| 6 | PIN_DATE_FROM_NUM | Number(8,0) | INTEGER NOT NULL |
Previous Period Date From Element
Prompt Table: %GP_EDIT_FLD1 |
| 7 | GP_AUD_CHAR_NM1 | 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 | GP_AUD_LINK1 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 10 | ENTRY_TYPE_TO | Character(3) | VARCHAR2(3) NOT NULL |
Entry Type for Date To Element
Prompt Table: GP_ENT_DATE_VW |
| 11 | DATE_TO | Date(10) | DATE | Previous Period Date To |
| 12 | PIN_DATE_TO_NUM | Number(8,0) | INTEGER NOT NULL |
Previous Period To Date Element
Prompt Table: %GP_EDIT_FLD2 |
| 13 | GP_AUD_CHAR_NM2 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 14 | GP_AUD_CHAR_VAL2 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 15 | GP_AUD_LINK2 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 16 | RETURN_DECIMALS | Character(1) | VARCHAR2(1) NOT NULL |
Return Duration With Decimals
Y/N Table Edit |
| 17 | PERIOD_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Period Option
D=Days M=Months Y=Years |
| 18 | ROUND_MONTH_IND | Character(1) | VARCHAR2(1) NOT NULL |
Add 1 Year if >=
Y/N Table Edit |
| 19 | ROUND_MONTH_VAL | Number(2,0) | SMALLINT NOT NULL | Round Months Number |
| 20 | ROUND_DAY_IND | Character(1) | VARCHAR2(1) NOT NULL |
Add 1 Month if >=
Y/N Table Edit |
| 21 | ROUND_DAY_VAL | Number(2,0) | SMALLINT NOT NULL | Round Day Number |
| 22 | GNRN_STAT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Y/N indicates whether or not periods of time is included in the resolution of a duration element considers the payees employee status or not
Y/N Table Edit |
| 23 | DUR_EMPLSTAT_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Used with Duration elements. Indicates whether to include or exclude days based on the payees HR status on the day. You can further indicate whether days should be included or excluded based on the time the payee was in that status. For example:
- Always include days when payee was Active.
- Include days when payee was suspended if he was in that status for less than a month.
E=Excluded I=Included |
| 24 | INCL_DUR_LIMIT_IND | Character(1) | VARCHAR2(1) NOT NULL |
Indicator to count Days 'Inclusive' or 'Exclusive' of the From and To Dates.
Y/N Table Edit |
| 25 | INCL_ABS_HIST_IND | Character(1) | VARCHAR2(1) NOT NULL |
Include Absence Days
Y/N Table Edit |
| 26 | PIN_FRML_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Prompt Table: GP_PIN_FM2_VW |
| 27 | GP_AUD_CHAR_NM3 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 28 | GP_AUD_CHAR_VAL3 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 29 | GP_AUD_LINK3 | Character(30) | VARCHAR2(30) NOT NULL | used in payroll analytics |
| 30 | GP_VERSION | Character(18) | VARCHAR2(18) NOT NULL | Stores element version. |
| 31 | GROUPBOX_DUR | Character(1) | VARCHAR2(1) NOT NULL | Generic groupbox field. |
| 32 | GROUPBOX_DUR2 | Character(1) | VARCHAR2(1) NOT NULL | Generic groupbox field. |
| 33 | GROUPBOX_DUR3 | Character(1) | VARCHAR2(1) NOT NULL | Generic groupbox field. |
| 34 | GROUPBOX_DUR4 | Character(1) | VARCHAR2(1) NOT NULL | Generic groupbox field. |
| 35 | GROUPBOX_DUR5 | Character(1) | VARCHAR2(1) NOT NULL | Generic groupbox field. |