CP_VAR_TMP_VW(SQL View) |
Index Back |
---|---|
CP Template Variable TypesCP Template Variable Types |
SELECT X.FIELDVALUE , X.XLATSHORTNAME , X.XLATLONGNAME FROM PSXLATITEM X WHERE X.FIELDNAME = 'VAR_INTL_CD' AND X.FIELDVALUE IN ('01','02','03','04','05','11','14') AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND X.EFF_STATUS = 'A' |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | VAR_INTL_CD | Character(2) | VARCHAR2(2) NOT NULL |
International Variable Type
01=Option 02=Secondary 03=Global 04=Matrix 05=Internal 06=Multiple Option 07=Value List 08=External Program 09=Character 10=Number 11=Literal 12=Boolean 14=Constant 15=Expression 16=Message |
2 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
3 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |