RF_ASSIGN_AET (SQL Table)	Index Back
Assignment Engine State Table This is the state table for the AE Assignment Engine Program.

RF_ASSIGN_AET

(SQL Table)

Assignment Engine State Table

This is the state table for the AE Assignment Engine Program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance

2 PROVIDER_GRP_ID Character(10) VARCHAR2(10) NOT NULL Identification number for the provider group.

3 PERSON_ID Character(15) VARCHAR2(15) NOT NULL Person ID

4 SCORE Number(7,2) DECIMAL(6,2) NOT NULL Test Score

5 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

6 SETID_CUSTOMER Character(5) VARCHAR2(5) NOT NULL Customer SetID

7 SETID_PROV_GRP Character(5) VARCHAR2(5) NOT NULL SetID

8 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

9 SETID_PROD_GRP Character(5) VARCHAR2(5) NOT NULL Product Group setid field

10 SETID_PRODUCT Character(5) VARCHAR2(5) NOT NULL Product SetID

11 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID

12 SETID_SERVICE Character(5) VARCHAR2(5) NOT NULL This field is used to represent the SETID of the Service

13 SITE_SETID Character(5) VARCHAR2(5) NOT NULL This field is used to represent the SETID of the Site

14 WHERE_CLAUSE Character(254) VARCHAR2(254) NOT NULL Where Clause

15 SO_ID Character(10) VARCHAR2(10) NOT NULL Service Order ID

16 SO_LINE Number(3,0) SMALLINT NOT NULL Stores the Service Order line number.

17 ACTIVITY_CODE Character(8) VARCHAR2(8) NOT NULL Activity Code which identifies the specific Activities which will be performed as part of Service Orders.

18 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

19 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.

20 REGION_ID Character(15) VARCHAR2(15) NOT NULL This field stores the region id value.

21 BO_ID_CUST Number(31,0) DECIMAL(31) NOT NULL This field stores the Business Object ID for the customer.

22 ROLE_TYPE_ID_CUST Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the customer

23 BO_ID_CNTCT Number(31,0) DECIMAL(31) NOT NULL This field represents the business object ID for a Contact

24 ROLE_TYPE_ID_CNTCT Number(12,0) DECIMAL(12) NOT NULL Stores ROLE_TYPE_ID for the contact

25 SITE_ID Character(15) VARCHAR2(15) NOT NULL Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.

26 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

27 PRODUCT_GROUP Character(10) VARCHAR2(10) NOT NULL PRoduct Group

28 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.

29 DEPTID Character(15) VARCHAR2(15) NOT NULL Department

30 SERVICE_ID Character(20) VARCHAR2(20) NOT NULL Service ID

31 COMP_LEVEL Character(1) VARCHAR2(1) NOT NULL Record level of competency

32 START_TIME Time(15) TIMESTAMP Start of Shift

33 END_TIME Time(15) TIMESTAMP End of Shift

34 START_DT Date(10) DATE Start date field to store start date value.

35 END_DT Date(10) DATE This field stores the end date values.

36 START_DAY_OF_WEEK Number(1,0) SMALLINT NOT NULL Integer representing the day of the week. (e.g. 1 = Sunday, 2 = Monday, etc.)

37 END_DAY_OF_WEEK Number(1,0) SMALLINT NOT NULL Integer representing the day of the week. (e.g. 1 = Sunday, 2 = Monday, etc.)

38 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency - this field is brought over from HRMS

39 PROFICIENCY Character(1) VARCHAR2(1) NOT NULL Proficiency Field. This Field is imported into CRM DB from Human Resources Database.

40 MAX_PROFICIENCY Number(3,0) SMALLINT NOT NULL Maximum Proficiency

41 SCORE_DENOM Number(7,2) DECIMAL(6,2) NOT NULL Assignment Fit Score denominator. Used when assigning a technicain to a service order, or an agent to a case.

42 COMPETENCY_DENOM Number(7,2) DECIMAL(6,2) NOT NULL Assignment Fit Score denominator. Used when assigning a technicain to a service order, or an agent to a case.

43 REVIEW_POINTS Number(3,0) SMALLINT NOT NULL REVIEW_POINTS field used in the HCM/ CRM sync Application Messages.

44 PROFICIENCY_NUM Number(2,0) SMALLINT NOT NULL Numeric version of PROFICIENCY used for calculations.

45 CRITERIA_IMPORTNCE Number(2,0) SMALLINT NOT NULL Criteria Importance

46 CRITERIA_WEIGHT Number(2,0) SMALLINT NOT NULL Competency Weight

47 CRITERIA_CODE Character(2) VARCHAR2(2) NOT NULL A code representing the type of criteria that will be used to match people with Service Orders or Call Center Cases. If a new translate value is added or deleted, then change &NumFactors in People Code. If a translate value is added/changed/deleted here, check to see if it needs to be added to CRITERIA_CODE_PER as well.
1=Customer
10=Department
11=Security Role
12=Person Type
2=Region
3=Product
4=Product Group
5=Site
6=Competency - Service
7=Location
8=Competency - CTD
9=Competency - Problem Type

48 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section

49 PG_SEARCH Character(1) VARCHAR2(1) NOT NULL Suggest a Provider Group

50 WORKER_SEARCH Character(1) VARCHAR2(1) NOT NULL Used to identify whether or not the Assignment Engine search is for a worker.

51 TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name

52 RATING_MODEL Character(4) VARCHAR2(4) NOT NULL RATING_MODEL field used in the HCM/ CRM sync Application Messages.

53 MAX_PRODUCT_PROF Number(3,0) SMALLINT NOT NULL Work field used to obtain the maximum product proficiency, as specified in the product rating model.

54 AVAILABILITY_FLAG Character(1) VARCHAR2(1) NOT NULL Flag to indicate that someone or something is available.

55 RC_SETID Character(5) VARCHAR2(5) NOT NULL Setid work field ....................................

56 RC_CASE_COUNT Number(7,0) INTEGER NOT NULL Case Count

57 COUNT_TOTAL Number(9,0) DECIMAL(9) NOT NULL Total Count

58 RC_CHILD_SETID Character(5) VARCHAR2(5) NOT NULL Child SetID

59 RC_CATEGORY Character(5) VARCHAR2(5) NOT NULL CallCenter Category. Used in HD.

60 RC_TYPE Character(5) VARCHAR2(5) NOT NULL Specialty type. Used on HD case.

61 RC_DETAIL Character(5) VARCHAR2(5) NOT NULL Detail field on HD Case. Used in Quick Code.

62 PROBLEM_TYPE Character(8) VARCHAR2(8) NOT NULL Problem Type for Support Cases

63 TEXT80 Character(80) VARCHAR2(80) NOT NULL Generic 80 Char text field. Not much more to say about that.

64 DISPLAY_FLAG Character(1) VARCHAR2(1) NOT NULL Display on Chart

65 DATE_UNDER_RPT Date(10) DATE Date Under Report

66 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

67 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Copied from Resouce Management (8.1). Added new label id for "Task Type"

68 TIME_START Time(15) TIMESTAMP Start Time

69 TIME_TO Time(15) TIMESTAMP To Time

70 DATE_BEGIN Date(10) DATE Start Date

71 DATE_END Date(10) DATE End Date

72 START_TM Time(15) TIMESTAMP Represents the process starting time associated with position calculation.

73 END_TM Time(15) TIMESTAMP End Time

74 RPT_DT Date(10) DATE Report Date

75 TIMEZONE Character(9) VARCHAR2(9) NOT NULL Time Zone

76 TIMEZONE2 Character(9) VARCHAR2(9) NOT NULL Time Zone

77 TEXT254 Character(254) VARCHAR2(254) NOT NULL Text

78 DAYOFWEEK Number(1,0) SMALLINT NOT NULL Day of Week

79 DAYOFWK Number(1,0) SMALLINT NOT NULL Day of Week

80 SQL_STMT_254 Character(254) VARCHAR2(254) NOT NULL An internal work field that contains SQL text that is to be utilized in treasury application p

81 TEXT100 Character(100) VARCHAR2(100) NOT NULL Set instruction text for role selection.

82 CM_ID Number(31,0) DECIMAL(31) NOT NULL Contact Method ID

83 PROFILE_CM_SEQ Number(31,0) DECIMAL(31) NOT NULL The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.

84 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

85 PARENT_REGION_ID Character(15) VARCHAR2(15) NOT NULL Unique identifier for Parent Region.
Prompt Table: RB_REGION_SRCH

86 CHILD_REGION_ID Character(15) VARCHAR2(15) NOT NULL The region ID of a child region

87 LIC_PROD_CD Character(18) VARCHAR2(18) NOT NULL Licensed product code for the configurable component.

88 BO_ID_PERSON Number(31,0) DECIMAL(31) NOT NULL Business Object ID

89 PERSON_ROLE Character(2) VARCHAR2(2) NOT NULL This field is used to store the Role Type for the worker.
86=Employee
87=Contingent Worker
88=Person of Interest

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
3	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
4	SCORE	Number(7,2)	DECIMAL(6,2) NOT NULL	Test Score
5	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables.
6	SETID_CUSTOMER	Character(5)	VARCHAR2(5) NOT NULL	Customer SetID
7	SETID_PROV_GRP	Character(5)	VARCHAR2(5) NOT NULL	SetID
8	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
9	SETID_PROD_GRP	Character(5)	VARCHAR2(5) NOT NULL	Product Group setid field
10	SETID_PRODUCT	Character(5)	VARCHAR2(5) NOT NULL	Product SetID
11	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
12	SETID_SERVICE	Character(5)	VARCHAR2(5) NOT NULL	This field is used to represent the SETID of the Service
13	SITE_SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to represent the SETID of the Site
14	WHERE_CLAUSE	Character(254)	VARCHAR2(254) NOT NULL	Where Clause
15	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
16	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Stores the Service Order line number.
17	ACTIVITY_CODE	Character(8)	VARCHAR2(8) NOT NULL	Activity Code which identifies the specific Activities which will be performed as part of Service Orders.
18	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
19	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.
20	REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	This field stores the region id value.
21	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
22	ROLE_TYPE_ID_CUST	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the customer
23	BO_ID_CNTCT	Number(31,0)	DECIMAL(31) NOT NULL	This field represents the business object ID for a Contact
24	ROLE_TYPE_ID_CNTCT	Number(12,0)	DECIMAL(12) NOT NULL	Stores ROLE_TYPE_ID for the contact
25	SITE_ID	Character(15)	VARCHAR2(15) NOT NULL	Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
26	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
27	PRODUCT_GROUP	Character(10)	VARCHAR2(10) NOT NULL	PRoduct Group
28	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
29	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
30	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID
31	COMP_LEVEL	Character(1)	VARCHAR2(1) NOT NULL	Record level of competency
32	START_TIME	Time(15)	TIMESTAMP	Start of Shift
33	END_TIME	Time(15)	TIMESTAMP	End of Shift
34	START_DT	Date(10)	DATE	Start date field to store start date value.
35	END_DT	Date(10)	DATE	This field stores the end date values.
36	START_DAY_OF_WEEK	Number(1,0)	SMALLINT NOT NULL	Integer representing the day of the week. (e.g. 1 = Sunday, 2 = Monday, etc.)
37	END_DAY_OF_WEEK	Number(1,0)	SMALLINT NOT NULL	Integer representing the day of the week. (e.g. 1 = Sunday, 2 = Monday, etc.)
38	COMPETENCY	Character(8)	VARCHAR2(8) NOT NULL	Competency - this field is brought over from HRMS
39	PROFICIENCY	Character(1)	VARCHAR2(1) NOT NULL	Proficiency Field. This Field is imported into CRM DB from Human Resources Database.
40	MAX_PROFICIENCY	Number(3,0)	SMALLINT NOT NULL	Maximum Proficiency
41	SCORE_DENOM	Number(7,2)	DECIMAL(6,2) NOT NULL	Assignment Fit Score denominator. Used when assigning a technicain to a service order, or an agent to a case.
42	COMPETENCY_DENOM	Number(7,2)	DECIMAL(6,2) NOT NULL	Assignment Fit Score denominator. Used when assigning a technicain to a service order, or an agent to a case.
43	REVIEW_POINTS	Number(3,0)	SMALLINT NOT NULL	REVIEW_POINTS field used in the HCM/ CRM sync Application Messages.
44	PROFICIENCY_NUM	Number(2,0)	SMALLINT NOT NULL	Numeric version of PROFICIENCY used for calculations.
45	CRITERIA_IMPORTNCE	Number(2,0)	SMALLINT NOT NULL	Criteria Importance
46	CRITERIA_WEIGHT	Number(2,0)	SMALLINT NOT NULL	Competency Weight
47	CRITERIA_CODE	Character(2)	VARCHAR2(2) NOT NULL	A code representing the type of criteria that will be used to match people with Service Orders or Call Center Cases. If a new translate value is added or deleted, then change &NumFactors in People Code. If a translate value is added/changed/deleted here, check to see if it needs to be added to CRITERIA_CODE_PER as well. 1=Customer 10=Department 11=Security Role 12=Person Type 2=Region 3=Product 4=Product Group 5=Site 6=Competency - Service 7=Location 8=Competency - CTD 9=Competency - Problem Type
48	AE_SECTION	Character(8)	VARCHAR2(8) NOT NULL	Section
49	PG_SEARCH	Character(1)	VARCHAR2(1) NOT NULL	Suggest a Provider Group
50	WORKER_SEARCH	Character(1)	VARCHAR2(1) NOT NULL	Used to identify whether or not the Assignment Engine search is for a worker.
51	TABLE_NAME	Character(30)	VARCHAR2(30) NOT NULL	Table Name
52	RATING_MODEL	Character(4)	VARCHAR2(4) NOT NULL	RATING_MODEL field used in the HCM/ CRM sync Application Messages.
53	MAX_PRODUCT_PROF	Number(3,0)	SMALLINT NOT NULL	Work field used to obtain the maximum product proficiency, as specified in the product rating model.
54	AVAILABILITY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Flag to indicate that someone or something is available.
55	RC_SETID	Character(5)	VARCHAR2(5) NOT NULL	Setid work field ....................................
56	RC_CASE_COUNT	Number(7,0)	INTEGER NOT NULL	Case Count
57	COUNT_TOTAL	Number(9,0)	DECIMAL(9) NOT NULL	Total Count
58	RC_CHILD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Child SetID
59	RC_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	CallCenter Category. Used in HD.
60	RC_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Specialty type. Used on HD case.
61	RC_DETAIL	Character(5)	VARCHAR2(5) NOT NULL	Detail field on HD Case. Used in Quick Code.
62	PROBLEM_TYPE	Character(8)	VARCHAR2(8) NOT NULL	Problem Type for Support Cases
63	TEXT80	Character(80)	VARCHAR2(80) NOT NULL	Generic 80 Char text field. Not much more to say about that.
64	DISPLAY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Display on Chart
65	DATE_UNDER_RPT	Date(10)	DATE	Date Under Report
66	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
67	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Copied from Resouce Management (8.1). Added new label id for "Task Type"
68	TIME_START	Time(15)	TIMESTAMP	Start Time
69	TIME_TO	Time(15)	TIMESTAMP	To Time
70	DATE_BEGIN	Date(10)	DATE	Start Date
71	DATE_END	Date(10)	DATE	End Date
72	START_TM	Time(15)	TIMESTAMP	Represents the process starting time associated with position calculation.
73	END_TM	Time(15)	TIMESTAMP	End Time
74	RPT_DT	Date(10)	DATE	Report Date
75	TIMEZONE	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
76	TIMEZONE2	Character(9)	VARCHAR2(9) NOT NULL	Time Zone
77	TEXT254	Character(254)	VARCHAR2(254) NOT NULL	Text
78	DAYOFWEEK	Number(1,0)	SMALLINT NOT NULL	Day of Week
79	DAYOFWK	Number(1,0)	SMALLINT NOT NULL	Day of Week
80	SQL_STMT_254	Character(254)	VARCHAR2(254) NOT NULL	An internal work field that contains SQL text that is to be utilized in treasury application p
81	TEXT100	Character(100)	VARCHAR2(100) NOT NULL	Set instruction text for role selection.
82	CM_ID	Number(31,0)	DECIMAL(31) NOT NULL	Contact Method ID
83	PROFILE_CM_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	The Contact Method Profile ID is a key field that is used to reference the details of a Contact Method in various CM tables.
84	ROLENAME	Character(30)	VARCHAR2(30) NOT NULL	The name of a Role in the Role Definition Table (see PSROLEDEFN).
85	PARENT_REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	Unique identifier for Parent Region. Prompt Table: RB_REGION_SRCH
86	CHILD_REGION_ID	Character(15)	VARCHAR2(15) NOT NULL	The region ID of a child region
87	LIC_PROD_CD	Character(18)	VARCHAR2(18) NOT NULL	Licensed product code for the configurable component.
88	BO_ID_PERSON	Number(31,0)	DECIMAL(31) NOT NULL	Business Object ID
89	PERSON_ROLE	Character(2)	VARCHAR2(2) NOT NULL	This field is used to store the Role Type for the worker. 86=Employee 87=Contingent Worker 88=Person of Interest