RF_AGLN_CAT5_VW (SQL View)	Index Back
Agreement Line: Locations View for Location Category values used in Internal Agreements to designate sets of employees who qualify for the entitlements of the corresponding agreement line.

RF_AGLN_CAT5_VW

(SQL View)

Agreement Line: Locations

View for Location Category values used in Internal Agreements to designate sets of employees who qualify for the entitlements of the corresponding agreement line.

SELECT SETID , AGREEMENT_CODE , AGR_RENEWAL_NUM , AGREEMENT_LINE , %subrec(RF_AGLN_CAT_SBR, A) FROM PS_RF_AGLN_CAT A WHERE A.AG_CAT_TYPE = '005'

# 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 AGREEMENT_CODE Character(30) VARCHAR2(30) NOT NULL This field represents the agreement code (name) for an agreement

3 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)

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

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

6 AG_CAT_TYPE Character(3) VARCHAR2(3) NOT NULL Agreement Category types for use in Agreement Search and weighting
001=Role
002=Department
003=Priority
004=Source
005=Location

7 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

8 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department SetID
Prompt Table: SP_DPTSET_NONVW

9 DEPTID Character(15) VARCHAR2(15) NOT NULL Department
Prompt Table: RF_CAT_DEPT_VW

10 RC_PRIORITY Character(5) VARCHAR2(5) NOT NULL Case Priority
Prompt Table: RC_PRIORITY_TBL

11 RC_SOURCE Character(5) VARCHAR2(5) NOT NULL Case Source How this case origianated
Prompt Table: RC_SOURCE_TBL

12 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID
Prompt Table: SP_LOCSET_NONVW

13 LOCATION Character(15) VARCHAR2(15) NOT NULL This field stores the Location Code.
Prompt Table: RF_CAT_LOC_VW

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

15 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

16 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

17 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

18 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

19 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	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	AGREEMENT_CODE	Character(30)	VARCHAR2(30) NOT NULL	This field represents the agreement code (name) for an agreement
3	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)
4	AGREEMENT_LINE	Character(10)	VARCHAR2(10) NOT NULL	This field records the value for the agreement line number
5	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number
6	AG_CAT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Agreement Category types for use in Agreement Search and weighting 001=Role 002=Department 003=Priority 004=Source 005=Location
7	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
8	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department SetID Prompt Table: SP_DPTSET_NONVW
9	DEPTID	Character(15)	VARCHAR2(15) NOT NULL	Department Prompt Table: RF_CAT_DEPT_VW
10	RC_PRIORITY	Character(5)	VARCHAR2(5) NOT NULL	Case Priority Prompt Table: RC_PRIORITY_TBL
11	RC_SOURCE	Character(5)	VARCHAR2(5) NOT NULL	Case Source How this case origianated Prompt Table: RC_SOURCE_TBL
12	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID Prompt Table: SP_LOCSET_NONVW
13	LOCATION	Character(15)	VARCHAR2(15) NOT NULL	This field stores the Location Code. Prompt Table: RF_CAT_LOC_VW
14	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
15	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
16	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
17	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
18	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
19	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time