CP_OPER_XVW_LNG(SQL View) |
Index Back |
---|---|
International Code XLAT LngThis record is used to translate languages for Variable International Code that are used in the Variable Search Page (CP_VAR_IN2) |
SELECT X.FIELDVALUE , L.LANGUAGE_CD , L.XLATSHORTNAME , L.XLATLONGNAME FROM PSXLATITEM X , PSXLATITEMLANG L WHERE X.FIELDNAME = 'OPER_INTL_CD' AND X.EFF_STATUS = 'A' AND %EffdtCheck(PSXLATITEM XX, X, %CurrentDateIn) AND %Join(COMMON_KEYS, PSXLATITEM X, PSXLATITEMLANG L, EFFDT) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPER_INTL_CD | Character(2) | VARCHAR2(2) NOT NULL |
International Operand Code
01=Equal to 02=Less than 03=Less than or Equal to 04=Greater than 05=Greater than or Equal to 06=If 07=Or 08=And 09=Not Equal To 10=Concate 11=Substring After 12=Substring Before 13=Exist on Multiple Option 14=Exist on Value List 15=Sin 16=Cosine 17=Tangent 18=Power 19=Mod 20=Add 21=Subtract 22=Multiply 23=Divide 24=Round Down 25=Round Up 26=Calculate Date 27=Exist on Component Array 28=Calculate Price |
2 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
3 | XLATSHORTNAME | Character(10) | VARCHAR2(10) NOT NULL | Translate Value Short Name |
4 | XLATLONGNAME | Character(30) | VARCHAR2(30) NOT NULL | Translate Long Name |