PGM_PRLATVAL_VW (SQL View)	Index Back
PRL Attributes Value View PRL Attributes Value View

PGM_PRLATVAL_VW

(SQL View)

PRL Attributes Value View

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.TEAM_MEMBER , A.RS_ATTRIBUTE_ID , A.RS_ATTR_VAL_ID , A.WEIGHT_POINTS FROM %Table(PGM_PRL_QL_ATVL) A WHERE EXISTS ( SELECT 'X' FROM %Table(RS_ATTRIBUTES) AA WHERE AA.RS_ATTRIBUTE_ID = A.RS_ATTRIBUTE_ID AND AA.PRL_REQ_ATTR_FLG = 'Y')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Default Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
Prompt Table: PROJECT_ALL_VW

3 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

4 RS_ATTRIBUTE_ID Character(10) VARCHAR2(10) NOT NULL This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker.
Prompt Table: RS_RQ_AT_VW

5 RS_ATTR_VAL_ID Character(10) VARCHAR2(10) NOT NULL Attribute Value ID

6 WEIGHT_POINTS Number(7,2) DECIMAL(6,2) NOT NULL Factor Weight Points

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField Prompt Table: PROJECT_ALL_VW
3	TEAM_MEMBER	Character(30)	VARCHAR2(30) NOT NULL	Team Member
4	RS_ATTRIBUTE_ID	Character(10)	VARCHAR2(10) NOT NULL	This field is used to uniquely identify an attribute of an assignment or project. An attribute may be captured on the service order and/or may be captured as an assignment preference by the worker. Prompt Table: RS_RQ_AT_VW
5	RS_ATTR_VAL_ID	Character(10)	VARCHAR2(10) NOT NULL	Attribute Value ID
6	WEIGHT_POINTS	Number(7,2)	DECIMAL(6,2) NOT NULL	Factor Weight Points