CP_SYSTABLECP_SYSKEYNUMCP_SYSKEY_VW(SQL View) |
Index Back |
|---|---|
CP System Key Field ViewView of PSDBFIELD, PSKEYDEFN |
| SELECT k.RECNAME , k.KEYPOSN , k.FIELDNAME , f.FIELDTYPE , f.LENGTH , f.DECIMALPOS FROM PSDBFIELD f , PSKEYDEFN k WHERE k.FIELDNAME = f.FIELDNAME AND k.INDEXID = '_' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CP_SYSTABLE |
Character(20) | VARCHAR2(20) NOT NULL | System Table Field |
| 2 | CP_SYSKEYNUM |
Number(3,0) | SMALLINT NOT NULL | System Key Number Field |
| 3 | TABLE_FIELD | Character(20) | VARCHAR2(20) NOT NULL | System Field Name |
| 4 | CP_SYSTYPE | Number(3,0) | SMALLINT NOT NULL | System Type Field |
| 5 | CP_SYSLENGTH | Number(5,0) | INTEGER NOT NULL | System Length Field |
| 6 | CP_SYSDECIMAL | Number(3,0) | SMALLINT NOT NULL | System Decimal Field |