| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
|
| 2 |
CASE_STATUS_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 3 |
CASE_PRIORIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 4 |
CASE_CATEGOR_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 5 |
CASE_TYPE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 6 |
CASE_IMPACT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 7 |
CASE_PROBTYP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 8 |
CASE_SEVERIT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 9 |
CASE_SOURCE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 10 |
PROVIDER_GRP_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 11 |
SETID_HDSTAT |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is for setid for header status
|
| 12 |
SETID_HOLD_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
SETID for the hold code
|
| 13 |
SETID_LNSTAT |
Character(5) |
VARCHAR2(5) NOT NULL |
This field is for the setid for line status.
|
| 14 |
PRODUCT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|
| 15 |
AGREEMENT_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
AGREEMENT_SETID field is added to the PROD_ITEM record. This is because we may select a template from a different SETID than the product definition
|
| 16 |
SETID_PROD_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Product Group setid field
|
| 17 |
SETID_CARRIER |
Character(5) |
VARCHAR2(5) NOT NULL |
Carrier Setid
|
| 18 |
SETID_SRC_CD |
Character(5) |
VARCHAR2(5) NOT NULL |
Setid Source Code
|
| 19 |
SETID_CAPTURE_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
MOC SETID Field
|
| 20 |
CASE_RELATE_SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
This is the field for Dashboard setid recname.
|