CA_CMPNT_VW_LG (SQL View)	Index Back
Amendment Exceptions Amendment Exceptions

CA_CMPNT_VW_LG

(SQL View)

Amendment Exceptions

SELECT A.FIELDVALUE , B.LANGUAGE_CD , B.XLATSHORTNAME FROM PSXLATITEM A , PSXLATITEMLANG B WHERE A.FIELDNAME = 'CONTRACT_COMPONENT' AND A.FIELDVALUE IN ('HDR' ,'LINE') AND %EffdtCheck(PSXLATITEM AA, A, %CurrentDateIn) AND %Join(COMMON_KEYS, PSXLATITEM A, PSXLATITEMLANG B)

Related Language Record for CA_COMPONENT_VW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_COMPONENT Character(4) VARCHAR2(4) NOT NULL Contract Component
AMT=Amount Allocation
BIL=Billing Plan
CHG=Amendments
EO=Early Out Options
HDR=Contract Header
LINE=Contract Line
MLST=Contract Milestone
PEN=Bonus/Penalty
PGP=Progress Payments Terms
PPD=Prepaids
PROJ=Contractor Terms
REV=Revenue Plan
TERM=Special Payment Terms

2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

3 DESCR20_MIXED Character(20) VARCHAR2(20) NOT NULL Description 20 characters, mixed case

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_COMPONENT	Character(4)	VARCHAR2(4) NOT NULL	Contract Component AMT=Amount Allocation BIL=Billing Plan CHG=Amendments EO=Early Out Options HDR=Contract Header LINE=Contract Line MLST=Contract Milestone PEN=Bonus/Penalty PGP=Progress Payments Terms PPD=Prepaids PROJ=Contractor Terms REV=Revenue Plan TERM=Special Payment Terms
2	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
3	DESCR20_MIXED	Character(20)	VARCHAR2(20) NOT NULL	Description 20 characters, mixed case