GP_ABS_LVDNVWLN(SQL View) |
Index Back |
---|---|
Abs Leave Donation Lang ViewAbs Leave Donation Lang View |
SELECT OP.OPRID , P.COUNTRY , P.LVDN_PRGM_ID , P.LANGUAGE_CD , C.DESCR , P.DESCR FROM PS_GP_ABS_LVDN_LNG P , PS_GP_OPR_RULE_PRF OP , PS_COUNTRYTBL_LANG C WHERE (OP.COUNTRY = 'ALL' OR P.COUNTRY = OP.COUNTRY) AND P.COUNTRY = C.COUNTRY AND P.LANGUAGE_CD = C.LANGUAGE_CD |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: GP_CNTRY_OP_VW |
3 | LVDN_PRGM_ID | Character(10) | VARCHAR2(10) NOT NULL |
Leave Program
Prompt Table: GP_ABS_LVDN_VW |
4 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |