CS_CLSGRP_SVW

(SQL View)
Index Back

PTSF Clause Groups

Clause Groups for PTSF

SELECT D.SETID , D.CS_OBJECT_ID , D.CS_CLAUSE_GROUP FROM PS_CS_CLS_GRP_DTL D WHERE CS_OBJECT_TYPE = '0001'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CS_OBJECT_ID Character(20) VARCHAR2(20) NOT NULL Object id -- clause, section

Prompt Table: CS_OBJECTS_HDR

3 CS_CLAUSE_GROUP Character(10) VARCHAR2(10) NOT NULL Supplier contract Clause Group

Prompt Table: CS_CLS_GRP