PGM_ASS_STS_VW (SQL View)	Index Back
Currently Assigment Status View of currently Assigment Status used to relate with Assignments for a Generic Resource on Project Team.

PGM_ASS_STS_VW

(SQL View)

Currently Assigment Status

View of currently Assigment Status used to relate with Assignments for a Generic Resource on Project Team.

SELECT A.ASSIGNMENT_ID , A.ASSIGN_STS , A.APPR_STATUS FROM %Table(RS_ASSGN_STS) A WHERE A.LASTUPDDTTM = ( SELECT MAX(A_ED.LASTUPDDTTM) FROM %Table(RS_ASSGN_STS) A_ED WHERE A.ASSIGNMENT_ID = A_ED.ASSIGNMENT_ID)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

2 ASSIGN_STS Character(2) VARCHAR2(2) NOT NULL Assignment Status
A=Assign
C=Complete
I=Interview
P=Propose
R=Reject
S=Reserve
V=Pending Approval
X=Cancel
Prompt Table: RS_ASSGN_ST_TBL

3 APPR_STATUS Character(1) VARCHAR2(1) NOT NULL Approval status flag used on appr_inst_log and derived records to track virtual approver status
A=Approved
D=Denied
P=Pending

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID
2	ASSIGN_STS	Character(2)	VARCHAR2(2) NOT NULL	Assignment Status A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel Prompt Table: RS_ASSGN_ST_TBL
3	APPR_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Approval status flag used on appr_inst_log and derived records to track virtual approver status A=Approved D=Denied P=Pending