CS_CNT_STAGE

(SQL Table)
Index Back

Validation Details

Staging and validation record for staged contracts. Contains results of any failed validations

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
2 CS_ACTION Character(1) VARCHAR2(1) NOT NULL Contract Action Flag
D=Delete
N=None
R=Reprocess

Default Value: R

3 SETID Character(5) VARCHAR2(5) NOT NULL SetID
4 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID

Default Value: NEXT

5 CNTRCT_ID_DISTRIB Character(25) VARCHAR2(25) NOT NULL Distributor Contract ID

Default Value: NEXT

6 CHUNK_NBR Number(3,0) SMALLINT NOT NULL Chunk Sequence Number
7 CHUNKCOUNT Number(9,0) DECIMAL(9) NOT NULL Chunk Count
8 SUBNODE Character(30) VARCHAR2(30) NOT NULL Subscribing Node
9 EIP_CTL_ID Character(25) VARCHAR2(25) NOT NULL Enterprise Components EIP (enterprise integration point) control field
10 CS_CNTRCT_LOAD Character(1) VARCHAR2(1) NOT NULL Contract Load
11 CS_BODY Long Character CLOB stores the body text for clause/section.