JPM_CSC_CFG_IDLANGUAGE_CDJPM_CSC_NPCFGLV(SQL View) |
Index Back |
|---|---|
Configurable Compare Defn |
| SELECT B.JPM_CSC_CFG_ID , B.LANGUAGE_CD , B.DESCR50 FROM PS_JPM_CSC_DEFN A , PS_JPM_CSC_DEFN_LG B WHERE B.JPM_CSC_CFG_ID = A.JPM_CSC_CFG_ID AND A.JPM_PROFILE_USAGE='J' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_CSC_CFG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Compare Definition ID |
| 2 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 3 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |