CA_WTH_REL_VW (SQL View)	Index Back
Withholding Release View This view will only expose release status of 'I'n Process. Use by Billing to update the release status.

CA_WTH_REL_VW

(SQL View)

Withholding Release View

This view will only expose release status of 'I'n Process. Use by Billing to update the release status.

SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , WTHD_REL_STATUS , WTHD_RELEASE_AMT , WTHD_RELEASE_OPT , DESCR FROM PS_CA_WTH_RELEASE WTH WHERE WTHD_REL_STATUS = 'I' AND SEQ_NUM = ( SELECT MAX(SEQ_NUM) FROM PS_CA_WTH_RELEASE REL WHERE REL.CONTRACT_NUM = WTH.CONTRACT_NUM AND REL.CONTRACT_LINE_NUM = WTH.CONTRACT_LINE_NUM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
Prompt Table: CA_CNTR_SRCH_VW

2 CONTRACT_LINE_NUM Number(3,0) SMALLINT NOT NULL Contract Line Num

3 WTHD_REL_STATUS Character(1) VARCHAR2(1) NOT NULL Withholding Release Status
C=Complete
I=In Process
P=Pending
R=Ready

4 WTHD_RELEASE_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Withholding Release Amount

5 WTHD_RELEASE_OPT Character(1) VARCHAR2(1) NOT NULL Withholding Release Option
B=Bill
W=Write-Off

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CONTRACT_NUM	Character(25)	VARCHAR2(25) NOT NULL	Contract Prompt Table: CA_CNTR_SRCH_VW
2	CONTRACT_LINE_NUM	Number(3,0)	SMALLINT NOT NULL	Contract Line Num
3	WTHD_REL_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Withholding Release Status C=Complete I=In Process P=Pending R=Ready
4	WTHD_RELEASE_AMT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Withholding Release Amount
5	WTHD_RELEASE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Withholding Release Option B=Bill W=Write-Off
6	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description