PSARCH_IDDefault: PSARCHRUNCNTL.PSARCH_ID
PSARCH_OBJECTY/N Table Edit
Y/N Table Edit
RECNAMEPSARCHREC_VW |
| Platform | View Text |
|---|---|
| Default | 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 | Description |
|---|---|
| PSARCH_ID | Archive ID Default: PSARCHRUNCNTL.PSARCH_ID |
| PSARCH_OBJECT | Archive Object |
| PSARCH_BASEOBJECT | Base Object Y/N Table Edit |
| PSARCH_LINKTABLE | Link Table |
| PSARCH_BASETABLE | Base Table Y/N Table Edit |
| RECNAME | Record (Table) Name |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |