RF_ENTL_AET (SQL Table)	Index Back
Entitlement Search State Table This is the state table for the AE Entitlement Search Program.

RF_ENTL_AET

(SQL Table)

Entitlement Search State Table

This is the state table for the AE Entitlement Search Program.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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

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

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

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

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

7 BO_ID_CONTACT Number(31,0) DECIMAL(31) NOT NULL This field indicates the Business Object ID for the contact.

8 INST_PROD_ID Character(20) VARCHAR2(20) NOT NULL This field is used to represent the installed product ID (key field)

9 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

10 AGREEMENT_LINE Character(10) VARCHAR2(10) NOT NULL This field records the value for the agreement line number

11 AGR_RENEWAL_NUM Number(4,0) SMALLINT NOT NULL This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)

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

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

14 WARRANTY_NAME Character(40) VARCHAR2(40) NOT NULL This field is used to store the name of the warranty.

15 DESCR Character(30) VARCHAR2(30) NOT NULL Description

16 AGRT_STATUS Character(3) VARCHAR2(3) NOT NULL This field represents the agreement status value.
001=Pending
002=Pending Activation
003=Action Required
005=Active
009=Closed

17 PIN Number(9,0) DECIMAL(9) NOT NULL This field is used to store the Personal Identification Number

18 RUNDATE Date(10) DATE Process Scheduler Run Date

19 AG_SVC_LINE_PRICE Number(12,2) DECIMAL(11,2) NOT NULL Transaction price for service on an agreement line

20 PERSON_PIN Character(40) VARCHAR2(40) NOT NULL This field is used to store the Personal Identification Number of a person for use in agreements

21 SIN Character(40) VARCHAR2(40) NOT NULL This field is used to represent the Site Identification Number

22 PURCHASE_OPTN Character(4) VARCHAR2(4) NOT NULL This field is used to represent the purchase option (used in agreement pricing)
FLAT=Flat Rate
PRPD=Prepaid Cases/Services
TM=Time & Material

23 SERVICE_CTR Signed Number(10,2) DECIMAL(8,2) NOT NULL This field is used to represent the remaining quantity available for pre-paid services

24 SVC_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used to represent the transaction price unit type
CASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year

25 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL This field stores the Currency Code value.

26 PROD_SETID Character(5) VARCHAR2(5) NOT NULL Product SET ID

27 AGR_SETID Character(5) VARCHAR2(5) NOT NULL Used to temporarily store the setid for the agreement or entitlements.

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

29 GRP_MEMBER_ID Character(15) VARCHAR2(15) NOT NULL Used to store the PERSON_ID of each group member in the provider group.

30 PRPD_UNIT_TYPE Character(4) VARCHAR2(4) NOT NULL This field is used to represent the prepaid unit type
CASE=Case
DAY=Day
HOUR=Hour
MON=Month
SO=Service Order
WEEK=Week
YEAR=Year

31 SETID_WARRANTY Character(5) VARCHAR2(5) NOT NULL This field is used to represent the SETID of the Warranty

32 RC_VERTICAL Character(4) VARCHAR2(4) NOT NULL Specifies the CallCenter type. See translates for valid values.
HD=HelpDesk
SW=Support

33 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated

34 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority

35 MANAGER_LEVEL Character(2) VARCHAR2(2) NOT NULL Manager Level.
0=Chief Operating Officer
1=Director
2=Senior Officer
3=Vice President
4=Senior Manager
5=Mid-Level Manager
6=First-Line Manager
7=Supervisor
8=All Other Positions
9=Non-Manager

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

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

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

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

40 ROLETYPE_CW Character(1) VARCHAR2(1) NOT NULL Flag value to determine if the worker has Contingent Worker Role Type.

41 ROLETYPE_EMP Character(1) VARCHAR2(1) NOT NULL Flag value to determine if the worker has Employee Role Type.

42 ROLETYPE_POI Character(1) VARCHAR2(1) NOT NULL Flag value to determine if the person has POI role type.

43 HR_STAT_ACTIVE Character(1) VARCHAR2(1) NOT NULL Flag for Active Worker Status.

44 HR_STAT_INACTIVE Character(1) VARCHAR2(1) NOT NULL Flag for Inactive Worker Status.

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

46 RH Character(1) VARCHAR2(1) NOT NULL HelpDesk

47 RHHR Character(1) VARCHAR2(1) NOT NULL HelpDesk for Human Resources

48 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID

49 ASSESS_DESCR Character(30) VARCHAR2(30) NOT NULL ASSESS_DESCR

50 CASE_TYPE Character(5) VARCHAR2(5) NOT NULL Case Type

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

52 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL This is the holiday schedule field.

53 SLA_SRCH_FLG Character(1) VARCHAR2(1) NOT NULL SLA search flag is used to store automatic agreement search options
L=Autoselect Single Longest
M=Show Result Page for Multiples
N=Do not Auto Search
S=Autoselect Single Shortest

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
2	BO_ID_CUST	Number(31,0)	DECIMAL(31) NOT NULL	This field stores the Business Object ID for the customer.
3	SO_ID	Character(10)	VARCHAR2(10) NOT NULL	Service Order ID
4	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.
5	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.
6	PERSON_ID	Character(15)	VARCHAR2(15) NOT NULL	Person ID
7	BO_ID_CONTACT	Number(31,0)	DECIMAL(31) NOT NULL	This field indicates the Business Object ID for the contact.
8	INST_PROD_ID	Character(20)	VARCHAR2(20) NOT NULL	This field is used to represent the installed product ID (key field)
9	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
10	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number
11	AGR_RENEWAL_NUM	Number(4,0)	SMALLINT NOT NULL	This field represents the agreement renewal number (agreements begin at a value of one and the number is incremented with every renewal)
12	SERVICE_ID	Character(20)	VARCHAR2(20) NOT NULL	Service ID
13	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
14	WARRANTY_NAME	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the name of the warranty.
15	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
16	AGRT_STATUS	Character(3)	VARCHAR2(3) NOT NULL	This field represents the agreement status value. 001=Pending 002=Pending Activation 003=Action Required 005=Active 009=Closed
17	PIN	Number(9,0)	DECIMAL(9) NOT NULL	This field is used to store the Personal Identification Number
18	RUNDATE	Date(10)	DATE	Process Scheduler Run Date
19	AG_SVC_LINE_PRICE	Number(12,2)	DECIMAL(11,2) NOT NULL	Transaction price for service on an agreement line
20	PERSON_PIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to store the Personal Identification Number of a person for use in agreements
21	SIN	Character(40)	VARCHAR2(40) NOT NULL	This field is used to represent the Site Identification Number
22	PURCHASE_OPTN	Character(4)	VARCHAR2(4) NOT NULL	This field is used to represent the purchase option (used in agreement pricing) FLAT=Flat Rate PRPD=Prepaid Cases/Services TM=Time & Material
23	SERVICE_CTR	Signed Number(10,2)	DECIMAL(8,2) NOT NULL	This field is used to represent the remaining quantity available for pre-paid services
24	SVC_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is used to represent the transaction price unit type CASE=Case DAY=Day HOUR=Hour MON=Month SO=Service Order WEEK=Week YEAR=Year
25	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	This field stores the Currency Code value.
26	PROD_SETID	Character(5)	VARCHAR2(5) NOT NULL	Product SET ID
27	AGR_SETID	Character(5)	VARCHAR2(5) NOT NULL	Used to temporarily store the setid for the agreement or entitlements.
28	PROVIDER_GRP_ID	Character(10)	VARCHAR2(10) NOT NULL	Identification number for the provider group.
29	GRP_MEMBER_ID	Character(15)	VARCHAR2(15) NOT NULL	Used to store the PERSON_ID of each group member in the provider group.
30	PRPD_UNIT_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This field is used to represent the prepaid unit type CASE=Case DAY=Day HOUR=Hour MON=Month SO=Service Order WEEK=Week YEAR=Year
31	SETID_WARRANTY	Character(5)	VARCHAR2(5) NOT NULL	This field is used to represent the SETID of the Warranty
32	RC_VERTICAL	Character(4)	VARCHAR2(4) NOT NULL	Specifies the CallCenter type. See translates for valid values. HD=HelpDesk SW=Support
33	RC_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated
34	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority
35	MANAGER_LEVEL	Character(2)	VARCHAR2(2) NOT NULL	Manager Level. 0=Chief Operating Officer 1=Director 2=Senior Officer 3=Vice President 4=Senior Manager 5=Mid-Level Manager 6=First-Line Manager 7=Supervisor 8=All Other Positions 9=Non-Manager
36	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department
37	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID
38	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
39	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code.
40	ROLETYPE_CW	Character(1)	VARCHAR2(1) NOT NULL	Flag value to determine if the worker has Contingent Worker Role Type.
41	ROLETYPE_EMP	Character(1)	VARCHAR2(1) NOT NULL	Flag value to determine if the worker has Employee Role Type.
42	ROLETYPE_POI	Character(1)	VARCHAR2(1) NOT NULL	Flag value to determine if the person has POI role type.
43	HR_STAT_ACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Flag for Active Worker Status.
44	HR_STAT_INACTIVE	Character(1)	VARCHAR2(1) NOT NULL	Flag for Inactive Worker Status.
45	LIC_PROD_CD	Character(18)	VARCHAR2(18) NOT NULL	Licensed product code for the configurable component.
46	RH	Character(1)	VARCHAR2(1) NOT NULL	HelpDesk
47	RHHR	Character(1)	VARCHAR2(1) NOT NULL	HelpDesk for Human Resources
48	ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	Role Type ID
49	ASSESS_DESCR	Character(30)	VARCHAR2(30) NOT NULL	ASSESS_DESCR
50	CASE_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Case Type
51	RC_CATEGORY	Character(5)	VARCHAR2(5) NOT NULL	CallCenter Category. Used in HD.
52	HOLIDAY_SCHEDULE	Character(6)	VARCHAR2(6) NOT NULL	This is the holiday schedule field.
53	SLA_SRCH_FLG	Character(1)	VARCHAR2(1) NOT NULL	SLA search flag is used to store automatic agreement search options L=Autoselect Single Longest M=Show Result Page for Multiples N=Do not Auto Search S=Autoselect Single Shortest