CA_CHG_HDR_VW2

(SQL View)
 Index Back

Change Header

Defines the change change package number and type for each contract and set of packages within the contract.

SELECT CONTRACT_NUM , CHG_ID FROM PS_CA_CHG_HDR WHERE CHG_ID <> '0000000000' AND CHG_STATUS <> 'C'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
2 CHG_ID Character(10) VARCHAR2(10) NOT NULL Change Package Identifier. This is sequenced from 1 to N for each contract.