CS_CNT_AGV_D_VW

(SQL View)
Index Back

SLA Monitor Verify

SCC 01/01/07 F-AHAYT-S60K7

SELECT B.SETID , B.CNTRCT_ID , B.VERSION_NBR , B.CNTRCT_LINE_NBR , B.CAT_LINE_NBR , B.CS_AGREE_SEQ5 , B.CS_VERIFY_SEQ , 0 , A.CS_SETID , A.CS_AGREE_CD , A.CS_COMPLIANCE_STAT , B.DUE_DT , B.DESCR60 , B.CS_ACTIVITY_STATUS , B.CS_VERIFY_METHOD , B.OPRDEFNDESC , B.CS_DATE_VERIFIED , B.CS_TIME_VERIFIED , B.CS_RESULT_YN , B.CS_COMMENTS FROM PS_CS_CNT_AG A , PS_CS_CNT_AG_VFY B WHERE %Join(COMMON_KEYS, CS_CNT_AG A, CS_CNT_AG_VFY B)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 VERSION_NBR Number(5,0) INTEGER NOT NULL Contract Version number
4 CNTRCT_LINE_NBR Number(5,0) INTEGER NOT NULL Buying Agreement Line Nbr
5 CAT_LINE_NBR Number(5,0) INTEGER NOT NULL Contract Category Line Number
6 CS_AGREE_SEQ5 Number(5,0) INTEGER NOT NULL Agreement Sequence for Supplier Contract Managment
7 CS_VERIFY_SEQ Number(5,0) INTEGER NOT NULL Contract Agreement Verification Step
8 CS_ATTACHMENT_SEQ5 Number(5,0) INTEGER NOT NULL Workflow Sequence for Supplier Contract Managment
9 CS_SETID Character(5) VARCHAR2(5) NOT NULL setid for the document objects
10 CS_AGREE_CD Character(18) VARCHAR2(18) NOT NULL Agreement Code for Supplier Contract Managment

Prompt Table: CS_AGREE

11 CS_COMPLIANCE_STAT Character(2) VARCHAR2(2) NOT NULL Compliance Status for Supplier Contract Managment
1=Compliant
2=Not Compliant
3=Not Set
4=Cancelled

Default Value: 3

12 CS_TARGET_DATE Date(10) DATE Contract Target Date for Supplier Contract Management
13 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
14 CS_ACTIVITY_STATUS Character(1) VARCHAR2(1) NOT NULL Contract Agreement Verification Activity Status
1=Completed
2=Failed
3=In Process
4=Not Started
5=Cancelled

Default Value: N

15 CS_VERIFY_METHOD Character(2) VARCHAR2(2) NOT NULL Verification Method for Supplier Contract Managment
AT=Attaching Supporting Document
CM=Comments
DT=Date/Time Stamp
NO=Notify Only
SY=System
YN=On Line Verification with Y/N
16 OPRDEFNDESC Character(30) VARCHAR2(30) NOT NULL Description field for a user
17 CS_DATE_VERIFIED Date(10) DATE Contract Agreement Date Verified
18 CS_TIME_VERIFIED Time(15) TIMESTAMP Contract Agreement Time Verified
19 CS_RESULT_YN Character(1) VARCHAR2(1) NOT NULL Negotiated Result for Supplier Contract Managment
N=No
Y=Yes
20 CS_COMMENTS Long Character CLOB Comment Field for Supplier Contract Managment