JPM_CSC_GRP(SQL Table) |
Index Back |
|---|---|
Compare Result Groups |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(10) | VARCHAR2(10) NOT NULL | Compare Definition ID | |
| 2 | Number(2,0) | SMALLINT NOT NULL | Results Group Number | |
| 3 | JPM_GROUP_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Group Description |
| 4 | SEQNBR | Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 1 |
| 5 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Default Value: N |