COUNTRYELIG_GRPPIN_NUMEFFDTA=Active
I=Inactive
GP_AAT0_SS_VW(SQL View) |
Index Back |
|---|---|
Absence Takes in SSPrompt view used to list absence take elements available for Self Service |
| SELECT DISTINCT SS.COUNTRY , ELIG.ELIG_GRP , SS.PIN_TAKE_NUM , ELIG.EFFDT , PIN.PIN_NM , ELIG.EFF_STATUS , PIN.DESCR 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 WHERE PIN.PIN_NUM < 50000000 AND PIN.PIN_NUM = TK.PIN_NUM AND PIN.PIN_NUM = SS.PIN_TAKE_NUM AND SS.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 SS.EFF_STATUS = 'A' AND %EffdtCheck(GP_ABS_SS, SS, %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 | PIN_NUM |
Number(8,0) | INTEGER NOT NULL | PIN Number |
| 4 | EFFDT |
Date(10) | DATE | Effective Date |
| 5 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |
| 6 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 7 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |