HCMD_CLASSIDHCMD_VAR_VW(SQL View) |
Index Back |
|---|---|
View used for prompt tableView used for prompt table for Variables |
| SELECT DISTINCT A.HCMD_CLASSID , A.DESCR FROM PS_HCMD_META_TBL A , PS_HCMD_OBJS_TBL B , PS_HCMD_BASE_TBL C WHERE (A.HCMD_CLASSID = B.HCMD_CLASSID OR A.HCMD_CLASSID = C.HCMD_CLASSID) AND A.HCMD_METATYPE <> 'FORM' AND A.HCMD_USEINRULES = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HCMD_CLASSID |
Character(12) | VARCHAR2(12) NOT NULL | EI_CLASSID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |