CA_STAT_VW (SQL View)	Index Back
All Status values List of status

CA_STAT_VW

(SQL View)

All Status values

List of status

SELECT CA_STATUS , CA_PROC_STATUS , ' ' , COUNT(*) , SUM(CONTRACT_TOTAL_BIL) , ' ' FROM PS_CA_CONTR_HDR GROUP BY CA_STATUS , CA_PROC_STATUS

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 CA_STATUS Character(24) VARCHAR2(24) NOT NULL Contract Status

2 CA_PROC_STATUS Character(1) VARCHAR2(1) NOT NULL CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available.
A=Active
C=Closed
P=Pending
Default Value: P

3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name

4 NUM_RECORDS Number(15,0) DECIMAL(15) NOT NULL Number of Records

5 AMOUNT Signed Number(28,3) DECIMAL(26,3) NOT NULL Amount

6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	CA_STATUS	Character(24)	VARCHAR2(24) NOT NULL	Contract Status
2	CA_PROC_STATUS	Character(1)	VARCHAR2(1) NOT NULL	CA_STATUS is a user defined status field that maps (many to 1) to the contract Processing Status field. Process Status indicates what change processing is available. A=Active C=Closed P=Pending Default Value: P
3	XLATSHORTNAME	Character(10)	VARCHAR2(10) NOT NULL	Translate Value Short Name
4	NUM_RECORDS	Number(15,0)	DECIMAL(15) NOT NULL	Number of Records
5	AMOUNT	Signed Number(28,3)	DECIMAL(26,3) NOT NULL	Amount
6	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code