ABS_TYPE_OPTNLANGUAGE_CDGP_AB_TYP_LANG(SQL View) |
Index Back |
|---|---|
GP_AB_ABSTYP_VWGP_AB_ABSTYP_VW |
| SELECT DISTINCT a.abs_type_optn ,b.language_cd ,b.descr FROM PS_GP_ABS_ANLYTICS a ,PS_GP_ABS_TP_LANG b WHERE a.abs_type_optn=b.abs_type_optn AND (a.country=b.country OR b.country='ALL') AND b.effdt= ( SELECT MAX(ch.effdt) FROM PS_GP_ABS_TP_LANG ch WHERE b.used_by=ch.used_by AND b.abs_type_optn=ch.abs_type_optn AND b.language_cd=ch.language_cd AND b.country=ch.country) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ABS_TYPE_OPTN |
Character(3) | VARCHAR2(3) NOT NULL | Absence Type |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | ABS_TYPE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Absence Type Description |