SETIDCS_OBJECT_IDEFFDTDefault Value: %date
Y/N Table Edit
Default Value: N
AUC_ALTCLS_VW(SQL View) |
Index Back |
|---|---|
Sourcing Alternate Clause view |
| SELECT A.SETID , A.CS_OBJECT_ID , A.EFFDT , A.CS_ALT_OBJID , C.DESCR60 , B.CS_TITLE , B.NUM_CHILDREN , B.ALTS_EXIST FROM PS_CS_OBJECT_ALTS A , PS_CS_OBJECTS_DTL B , PS_CS_OBJECTS_HDR C WHERE A.CS_OBJECT_TYPE = '0001' AND B.SETID = A.SETID AND B.CS_OBJECT_TYPE = A.CS_OBJECT_TYPE AND B.CS_OBJECT_ID = A.CS_ALT_OBJID AND B.EFFDT = ( SELECT MAX(BB.EFFDT) FROM PS_CS_OBJECTS_DTL BB WHERE BB.SETID = B.SETID AND BB.CS_OBJECT_TYPE = B.CS_OBJECT_TYPE AND BB.CS_OBJECT_ID = B.CS_OBJECT_ID AND BB.EFFDT <= %CurrentDateIn AND BB.CS_APPROVAL_STATUS = 'A') AND C.SETID = B.SETID AND C.CS_OBJECT_ID = B.CS_OBJECT_ID AND C.CS_OBJECT_TYPE = B.CS_OBJECT_TYPE AND B.EFF_STATUS = 'A' |
| # | 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 |
| 3 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | CS_ALT_OBJID | Character(30) | VARCHAR2(30) NOT NULL | Alternate ID |
| 5 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 6 | CS_TITLE | Character(254) | VARCHAR2(254) NOT NULL | title |
| 7 | NUM_CHILDREN | Number(3,0) | SMALLINT NOT NULL | Number of children |
| 8 | ALTS_EXIST | Character(1) | VARCHAR2(1) NOT NULL |
cel - alternates exist flag in Contract Management
Y/N Table Edit Default Value: N |