JPM_CSC_CFG_IDJ=Non-Person
P=Person
Default Value: P
Default Value: N
JPM_CSC_DEFN(SQL Table) |
Index Back |
|---|---|
Configurable Compare Defn |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | JPM_CSC_CFG_ID |
Character(10) | VARCHAR2(10) NOT NULL | Compare Definition ID |
| 2 | DESCR50 | Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 3 | DESCRLONG | Long Character | CLOB | Long Description |
| 4 | JPM_PROFILE_USAGE | Character(1) | VARCHAR2(1) NOT NULL |
Value used to specify how the profile is used in business logic. This profile may represent a person profile, a profile in progress and not available for use, a job profile, etc.
J=Non-Person P=Person Default Value: P |
| 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 |