CA_CHG_STATS_VW (SQL View)	Index Back
Amendment Status Xlat View Amendment Status Xlat View

CA_CHG_STATS_VW

(SQL View)

Amendment Status Xlat View

SELECT A.FIELDVALUE , A.XLATLONGNAME FROM PSXLATITEM A WHERE A.FIELDNAME = 'CHG_STATUS' AND A.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PSXLATITEM A_ED WHERE A.FIELDNAME = A_ED.FIELDNAME AND A.FIELDVALUE = A_ED.FIELDVALUE AND A_ED.EFFDT <= %CurrentDateIn AND A_ED.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CHG_STATUS Character(1) VARCHAR2(1) NOT NULL Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied.
C=Complete
P=Pending
R=Ready
X=Cancelled

2 AMENDMENT_STATUS Character(30) VARCHAR2(30) NOT NULL Amendment Status

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CHG_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Change Status indicates if this change package is open for further edit: pending, ready for processing by the app. engine component of contract change management (ready) or complete, meaning that no further edit is possible and all changes have been aplied. C=Complete P=Pending R=Ready X=Cancelled
2	AMENDMENT_STATUS	Character(30)	VARCHAR2(30) NOT NULL	Amendment Status