IMP_CODESET_VW(SQL View) |
Index Back |
|---|---|
CDH IMP_CODESET_VWCDH IMP_CODESET_VW is used to join PSCODESETVAL_DE ,PSCODESETVAL and PSCODESET |
| SELECT A.CODESETGROUPNAME ,A.CODESETNAME ,A.TOCODESETGRPNAME ,A.SEQNUM ,CAST(REPLACE(A.CODESETCOMPKEY ,',' ,' ') AS INTEGER) ,( SELECT C.MATCHVALUE FROM PSCODESET C WHERE C.CODESETKEY = CAST(REPLACE(A.CODESETCOMPKEY,',',' ') AS INTEGER)) ,B.RETNAME ,B.RETVALUE FROM PSCODESETVAL_DE A ,PSCODESETVAL B WHERE B.CODESETGROUPNAME = A.CODESETGROUPNAME AND B.CODESETNAME = A.CODESETNAME AND B.TOCODESETGRPNAME = A.TOCODESETGRPNAME AND B.SEQNUM = A.SEQNUM |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CODESETGROUPNAME | Character(30) | VARCHAR2(30) NOT NULL | Code Set Group Name |
| 2 | CODESETNAME | Character(30) | VARCHAR2(30) NOT NULL | Codeset Name |
| 3 | TOCODESETGRPNAME | Character(30) | VARCHAR2(30) NOT NULL | Code Set Group Name |
| 4 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | CODESETKEY | Number(9,0) | DECIMAL(9) NOT NULL | Codeset Key |
| 6 | MATCHVALUE | Character(95) | VARCHAR2(95) NOT NULL | Match Value |
| 7 | RETNAME | Character(30) | VARCHAR2(30) NOT NULL | Return Name |
| 8 | RETVALUE | Character(100) | VARCHAR2(100) NOT NULL | Return Value |