CS_OBJ_HDR_VW2(SQL View) |
Index Back |
|---|---|
obj header view |
| SELECT SETID , CS_OBJECT_TYPE , CS_OBJECT_ID , DESCR60 , CS_SECTION_TYPE FROM PS_CS_OBJECTS_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW |
| 2 | CS_OBJ_TYPE_CHILD |
Character(4) | VARCHAR2(4) NOT NULL |
Clause/section dependent
0001=Clause 0002=Section 0004=Rule |
| 3 | CS_CHILD_OBJID |
Character(20) | VARCHAR2(20) NOT NULL | Child Object |
| 4 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 5 | CS_SECTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
CEL 01/2008 Adding SLA category placeholders
RMK 12/11/2007
Amendment Placeholder - enhancement to update 2nd amendment file with changes in amended document. Indicator to the system where to drop the changes in the amendment file
CEL 5/1/2005
SH and SL types are hidden from all pages/etc. Purely used internally in the table. So that is why they are marked inactive here .. to stop them from showing up on the pages. BUT we still need them as codes cause we use internally in code .. just didn't want to remove them and have them get accidentally used.
A=Amendment Placeholder G=General SC=Placeholder-Category Agreement SH=Placeholder-Header Agreement SL=Placeholder-Line Agreement T=Introduction/Title |