RC_ER_ASGN_HIST (SQL Table)	Index Back
Case Assignment and Access Record used to track Case Assignment and Access History

RC_ER_ASGN_HIST

(SQL Table)

Case Assignment and Access

Record used to track Case Assignment and Access History

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.
Default Value: RC_CASE.CASE_ID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: RC_CASE.BUSINESS_UNIT

3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number

4 ASSIGN_SEQ_NBR Number(3,0) SMALLINT NOT NULL Sequence number assignment

5 PRIMARY_FLG Character(1) VARCHAR2(1) NOT NULL This is a flag which takes yes or no values and indicates whether the row is primary.
N=No
Y=Yes
Default Value: N

6 RC_ASSIGNMENT_TYPE Character(1) VARCHAR2(1) NOT NULL Assignment Type identifies the type of person, or group assigned to the case
G=Group
I=Individual

7 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.
Prompt Table: RC_GRP_MEM_VW2
Set Control Field: BUSINESS_UNIT

8 PRIOR_PRVDR_GRP_ID Character(10) VARCHAR2(10) NOT NULL PRIOR PROVIDER GROUP ID field is used to store prior value of the Provider Group.

9 ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.
Prompt Table: %EDITTABLE42
Set Control Field: BUSINESS_UNIT

10 PRIOR_ASSIGNED_TO Character(15) VARCHAR2(15) NOT NULL This is a field to store assignment information.

11 RC_CASE_ACCESS Character(4) VARCHAR2(4) NOT NULL Case access field for employee relations cases
AGT1=Agent: Read/Write All Pages
PNL1=Panelist: Read/Write Case Note

12 START_DATE Date(10) DATE Start Date for Gen Standing PO
Default Value: %date

13 END_DATE Date(10) DATE End date field to store an end date.

14 COMMENTS254 Character(254) VARCHAR2(254) NOT NULL Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)

15 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

16 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
Prompt Table: RB_OPR_PR_NM_VW
Set Control Field: BUSINESS_UNIT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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. Default Value: RC_CASE.CASE_ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: RC_CASE.BUSINESS_UNIT
3	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
4	ASSIGN_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sequence number assignment
5	PRIMARY_FLG	Character(1)	VARCHAR2(1) NOT NULL	This is a flag which takes yes or no values and indicates whether the row is primary. N=No Y=Yes Default Value: N
6	RC_ASSIGNMENT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Assignment Type identifies the type of person, or group assigned to the case G=Group I=Individual
7	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group. Prompt Table: RC_GRP_MEM_VW2 Set Control Field: BUSINESS_UNIT
8	PRIOR_PRVDR_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	PRIOR PROVIDER GROUP ID field is used to store prior value of the Provider Group.
9	ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information. Prompt Table: %EDITTABLE42 Set Control Field: BUSINESS_UNIT
10	PRIOR_ASSIGNED_TO	Character(15)	VARCHAR2(15) NOT NULL	This is a field to store assignment information.
11	RC_CASE_ACCESS	Character(4)	VARCHAR2(4) NOT NULL	Case access field for employee relations cases AGT1=Agent: Read/Write All Pages PNL1=Panelist: Read/Write Case Note
12	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO Default Value: %date
13	END_DATE	Date(10)	DATE	End date field to store an end date.
14	COMMENTS254	Character(254)	VARCHAR2(254) NOT NULL	Shorter comment field (i.e. shorter than a long character) for situations where the longer field size is not necessary (especially if there's already another Long Char field in the record)
15	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
16	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row. Prompt Table: RB_OPR_PR_NM_VW Set Control Field: BUSINESS_UNIT