PSARCH_IDDefault Value: PSARCHRUNCNTL.PSARCH_ID
PSARCH_OBJECTY/N Table Edit
Y/N Table Edit
RECNAMEPSARCHREC_VW(SQL View) |
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 | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL |
Archive ID (see PSARCHTEMPLATE).
Default Value: PSARCHRUNCNTL.PSARCH_ID |
| 2 | PSARCH_OBJECT |
Character(30) | VARCHAR2(30) NOT NULL | Archive Object (see PSARCHOBJDEFN). |
| 3 | PSARCH_BASEOBJECT | Character(1) | VARCHAR2(1) NOT NULL |
Base Object
Y/N Table Edit |
| 4 | PSARCH_LINKTABLE | Character(15) | VARCHAR2(15) NOT NULL | Link Table |
| 5 | PSARCH_BASETABLE | Character(1) | VARCHAR2(1) NOT NULL |
Base Table
Y/N Table Edit |
| 6 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name (see PSRECDEFN). |