TABLE_NAMETABLE_FIELDCP_SYSRECFLD_VW(SQL View) |
Index Back |
|---|---|
CP System Record Field ViewView of PSDBFIELD, PSRECFIELD |
| SELECT r.RECNAME , f.FIELDNAME , f.FIELDTYPE , f.LENGTH , f.DECIMALPOS FROM PSDBFIELD f , PSRECFIELD r WHERE r.FIELDNAME = f.FIELDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TABLE_NAME |
Character(30) | VARCHAR2(30) NOT NULL | Table Name |
| 2 | TABLE_FIELD |
Character(20) | VARCHAR2(20) NOT NULL | System Field Name |
| 3 | CP_SYSTYPE | Number(3,0) | SMALLINT NOT NULL | System Type Field |
| 4 | CP_SYSLENGTH | Number(5,0) | INTEGER NOT NULL | System Length Field |
| 5 | CP_SYSDECIMAL | Number(3,0) | SMALLINT NOT NULL | System Decimal Field |