UUID_RAWCASE_IDC=Closed
D=Canceled
H=Case is on hold
O=Case is Open
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
A=Pending
N=Late
NA=Not Applicable
Y=On-Time
RC_HD_SLM_RPT(SQL Table) |
Index Back |
|---|---|
SLM Helpdesk BAM report tableOutput of BAM report AE program, and it is used to create query view for BAM import. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | UUID_RAW |
Character(36) | VARCHAR2(36) NOT NULL | Universal Unique Identifier - can be used as an identifier when processing a batch of data. |
| 2 | CASE_ID |
Number(15,0) | DECIMAL(15) NOT NULL | Case ID. This is a unique ID assigned to a case when it is saved. Unique ID is ensured by getting the next value from the auto-numbering table and updating the table. |
| 3 | BO_ID_CUST | Number(31,0) | DECIMAL(31) NOT NULL | This field stores the Business Object ID for the customer. |
| 4 | BO_NAME | Character(50) | VARCHAR2(50) NOT NULL | Name Description of Business Object |
| 5 | SETID_PRODUCT | Character(5) | VARCHAR2(5) NOT NULL | Product SetID |
| 6 | PRODUCT_ID | Character(18) | VARCHAR2(18) NOT NULL | Product ID |
| 7 | PRODUCT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Product Description |
| 8 | SETID_PROV_GRP | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 9 | PROVIDER_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL | Identification number for the provider group. |
| 10 | PROVIDER_GRP_NAME | Character(50) | VARCHAR2(50) NOT NULL | Provider Group Name |
| 11 | ASSIGNED_TO | Character(15) | VARCHAR2(15) NOT NULL | This is a field to store assignment information. |
| 12 | BO_NAME_DISPLAY | Character(80) | VARCHAR2(80) NOT NULL | Full name of the Business Object |
| 13 | SETID_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 14 | RC_PRIORITY | Character(5) | VARCHAR2(5) NOT NULL | Case Priority |
| 15 | RC_PRIORITY_SDESCR | Character(20) | VARCHAR2(20) NOT NULL | Priority Short Descr |
| 16 | SETID_STATUS | Character(5) | VARCHAR2(5) NOT NULL | MOC SETID Field |
| 17 | RC_STATUS | Character(5) | VARCHAR2(5) NOT NULL | Case Status |
| 18 | RC_SHORT_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Short Description. Used on may CallCenter set-up tables |
| 19 | 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 |
| 20 | DESCR20 | Character(20) | VARCHAR2(20) NOT NULL | Description 20 |
| 21 | SETID_DEPT | Character(5) | VARCHAR2(5) NOT NULL | Department SetID |
| 22 | DEPTID | Character(15) | VARCHAR2(15) NOT NULL | Department |
| 23 | RC_DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department Description to be displayed on HelpDesk page. |
| 24 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 25 | LOCATION | Character(15) | VARCHAR2(15) NOT NULL | This field stores the Location Code. |
| 26 | RC_LOC_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Descripton of the Location to be displayed in helpdesk page. |
| 27 | RC_RESP_IND | Character(4) | VARCHAR2(4) NOT NULL |
Response Indicator, to indicate different stage of response for SLA.
A=Pending N=Late NA=Not Applicable Y=On-Time |
| 28 | RC_REST_IND | Character(4) | VARCHAR2(4) NOT NULL |
Restore Indicator, indicate different stage of restore for SLA
A=Pending N=Late NA=Not Applicable Y=On-Time |
| 29 | HOLD_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Hold |