PSARCH_IDDefault: PSARCHRUNCNTL.PSARCH_ID
PSARCH_OBJECTY/N Table Edit
Y/N Table Edit
RECNAMEPSARCHREC_VW |
index back |
|---|---|
Records in Archive Template |
| SELECT A.PSARCH_ID , B.PSARCH_OBJECT , B.PSARCH_BASEOBJECT , B.PSARCH_LINKTABLE , C.PSARCH_BASETABLE , C.RECNAME FROM PSARCHTEMPLATE A , PSARCHTEMPOBJ B , PSARCHOBJREC C WHERE A.PSARCH_ID = B.PSARCH_ID AND B.PSARCH_OBJECT = C.PSARCH_OBJECT |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
Default: PSARCHRUNCNTL.PSARCH_ID |
| PSARCH_OBJECT |
Character(30) | VARCHAR2(30) NOT NULL | Archive Object (see PSARCHOBJDEFN). |
| PSARCH_BASEOBJECT | Character(1) | VARCHAR2(1) NOT NULL |
Base Object
Y/N Table Edit |
| PSARCH_LINKTABLE | Character(15) | VARCHAR2(15) NOT NULL | Link Table |
| PSARCH_BASETABLE | Character(1) | VARCHAR2(1) NOT NULL |
Base Table
Y/N Table Edit |
| RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |