CONTRACT_NUMPROJECT_IDBUSINESS_UNIT_PCGUIDE_IDPrompt Table: GM_GUIDELN_DTL
LANGUAGE_CDGM_GUIDE_DES_LV(SQL View) |
Index Back |
|---|---|
GM_GUIDE_DESC_L language view.Language view for GM_GUIDE_DESC_L. |
| SELECT A.CONTRACT_NUM , A.BUSINESS_UNIT , A.PROJECT_ID , BUSINESS_UNIT_PC , A.GUIDE_ID , C.LANGUAGE_CD , B.DESCR254 FROM PS_GM_AWD_TERMS A , PS_GM_AWD_GDLN_VW B , PS_GM_GUIDELN_LNG C WHERE ( A.GUIDE_ID = B.GUIDE_ID AND B.SETID = C.SETID AND B.GUIDE_ID = C.GUIDE_ID AND B.EFFDT = C.EFFDT AND B.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM PS_GM_AWD_GDLN_VW B_ED WHERE B.SETID = B_ED.SETID AND B.GUIDE_ID = B_ED.GUIDE_ID AND B_ED.EFFDT <= %CurrentDateIn)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CONTRACT_NUM |
Character(25) | VARCHAR2(25) NOT NULL | Contract |
| 2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 3 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 4 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 5 | GUIDE_ID |
Character(5) | VARCHAR2(5) NOT NULL |
Guideline ID
Prompt Table: GM_GUIDELN_DTL |
| 6 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 7 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |