# |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
1 |
CFG_COMPNT_ID |
Number(19,0) |
DECIMAL(19) NOT NULL |
Component Id
|
2 |
CFG_CD_ID |
Number(19,0) |
DECIMAL(19) NOT NULL |
Compound id
|
3 |
CFG_TYPE |
Character(64) |
VARCHAR2(64) NOT NULL |
Database value that contains the Configuration Type (internal vs external)
|
4 |
CFG_NAME |
Character(64) |
VARCHAR2(64) NOT NULL |
Database field that contains the name of the model
r
|
5 |
CFG_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Active status of configuration
|
6 |
CFG_CREATED_DTTM |
DateTime(26) |
TIMESTAMP |
Creation time
|
7 |
CFG_MODIFIED_DTTM |
DateTime(26) |
TIMESTAMP |
Modification time
|
8 |
CFG_COMMENT_ID |
Number(19,0) |
DECIMAL(19) NOT NULL |
Comment Id
|