HCMD_CLASSIDHCMD_ATTRIBIDLANGUAGE_CDWCS_SO_OATT_LVW(SQL View) |
Index Back |
|---|---|
Object Attributes LanguageRelated language table for WCS_SO_OATT_VW View of attribute descriptors for fields that are character, number or date. Used as prompt view for sources. |
| SELECT C.HCMD_CLASSID , C.HCMD_ATTRIBID , C.LANGUAGE_CD , C.DESCR FROM PS_HCMD_OATT_LNG C , PS_HCMD_OATT_TBL A , PSDBFIELD B WHERE C.HCMD_CLASSID = A.HCMD_CLASSID AND C.HCMD_ATTRIBID = A.HCMD_ATTRIBID AND A.ACTIVE_FLAG = 'A' AND A.FIELDNAME = B.FIELDNAME AND B.FIELDTYPE IN (0,2,3,4) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCMD_CLASSID |
Character(12) | VARCHAR2(12) NOT NULL | EI_CLASSID |
| 2 | HCMD_ATTRIBID |
Character(30) | VARCHAR2(30) NOT NULL | Created by Eric Solberg 2/18/02 Attribute name as defined by object descriptor |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |