COUNTRYELIG_GRPABS_TYPE_OPTNPIN_NUMEFFDTA=Administrator
B=Employee and Manager
E=Employee
M=Manager
A=Active
I=Inactive
GP_ABSEA_TK_VW(SQL View) |
Index Back |
|---|---|
EA Absence TakesPrompt view used to list absence take elements and take type available for EA Self Service |
| SELECT DISTINCT SS.COUNTRY , ELIG.ELIG_GRP , TK.ABS_TYPE_OPTN , SS.PIN_TAKE_NUM , ELIG.EFFDT , PIN.PIN_NM , SS.DISPLAY_ORDER , SS.RQST_ALLOWED_BY , ELIG.EFF_STATUS , PIN.DESCR , SS.ABS_TL_ENTRY_IND , SS.ALLOW_EA_ENTRY , SS.EFFDT , ELEM.EFFDT , TK.EFFDT , TY.EFFDT FROM PS_GP_PIN PIN , PS_GP_ABS_TAKE TK , PS_GP_ABS_SS SS , PS_GP_ELEM_GRP_MBR ELEMM , PS_GP_ELEM_GRP ELEM , PS_GP_ELIG_GRP_MBR ELIGM , PS_GP_ELIG_GRP ELIG , PS_GP_ABS_TYPE TY WHERE PIN.PIN_NUM < 50000000 AND PIN.PIN_NUM = TK.PIN_NUM AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND %EffdtCheck(GP_ABS_SS, SS, %CurrentDateIn) AND SS.EFF_STATUS = 'A' AND TY.REQUEST_IND = 'Y' AND PIN.PIN_NUM = ELEMM.PIN_ELEM_NUM AND ELEMM.PIN_NUM = ELEM.PIN_NUM AND ELEMM.EFFDT = ELEM.EFFDT AND %EffdtCheck(GP_ELEM_GRP, ELEM, %CurrentDateIn) AND ELEM.EFF_STATUS = 'A' AND ELEM.PIN_NUM = ELIGM.PIN_ELEM_GRP_NUM AND ELIGM.ELIG_GRP = ELIG.ELIG_GRP AND ELIGM.EFFDT = ELIG.EFFDT AND %EffdtCheck(GP_ABS_TAKE, TK, %CurrentDateIn) AND TK.EFF_STATUS = 'A' AND TY.COUNTRY = PIN.COUNTRY AND TY.ABS_TYPE_OPTN = TK.ABS_TYPE_OPTN AND %EffdtCheck(GP_ABS_TYPE, TY, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COUNTRY |
Character(3) | VARCHAR2(3) NOT NULL | Country |
| 2 | ELIG_GRP |
Character(10) | VARCHAR2(10) NOT NULL | eligibility group |
| 3 | ABS_TYPE_OPTN |
Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 4 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 5 | EFFDT |
Date(10) | DATE | Effective Date |
| 6 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 7 | DISPLAY_ORDER | Number(3,0) | SMALLINT NOT NULL | Display order for ordering items in a list - web style |
| 8 | RQST_ALLOWED_BY | Character(1) | VARCHAR2(1) NOT NULL |
This field dictates who can request a specific absence take in self-service.
A=Administrator B=Employee and Manager E=Employee M=Manager |
| 9 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 10 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 11 | ABS_TL_ENTRY_IND | Character(1) | VARCHAR2(1) NOT NULL | Absence Management - T/L Entry Indicator |
| 12 | ALLOW_EA_ENTRY | Character(1) | VARCHAR2(1) NOT NULL | Used to capture the setup data at country take on whether a take can be entered as an Extended Absence |
| 13 | DATE_DAY10 | Date(10) | DATE | DateDay10 |
| 14 | DATE_DAY11 | Date(10) | DATE | DateDay11 |
| 15 | DATE_DAY12 | Date(10) | DATE | DateDay12 |
| 16 | DATE_DAY13 | Date(10) | DATE | DateDay13 |