SETIDDefault Value: OPR_DEF_TBL_RB.SETID
Prompt Table: SP_SETID_NONVW
RC_STATUSC=Closed
D=Canceled
H=Case is on hold
O=Case is Open
N=No
Y=Yes
Y/N Table Edit
Default Value: N
RC_STATUS_VW(SQL View) |
Index Back |
|---|---|
Case Open and On-Hold StatusCase status view for only open and on-hold statuses. |
| SELECT SETID , RC_STATUS , STATUS_CATEGORY , BILLABLE_FLAG , RC_SHORT_DESCR , RC_DESCR_SS , LONG_DESC FROM PS_RC_STATUS_TBL WHERE STATUS_CATEGORY IN ('O', 'H') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL |
This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | RC_STATUS |
Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 3 | STATUS_CATEGORY | Character(1) | VARCHAR2(1) NOT NULL |
Categories for Case Status.
These drive processing.
C=Closed D=Canceled H=Case is on hold O=Case is Open |
| 4 | BILLABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This is used to determine of the item under consideration is billable or not.
N=No Y=Yes Y/N Table Edit Default Value: N |
| 5 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
| 6 | RC_DESCR_SS | Character(30) | VARCHAR2(30) NOT NULL | Description to be shown on Self-Service Pages |
| 7 | LONG_DESC | Character(50) | VARCHAR2(50) NOT NULL | Long Description field. |