PSARCH_IDRECNAMEPrompt Table: RECDEFN_VW
HIST_RECNAMEARCH_TBL_VW(SQL View) |
Index Back |
|---|---|
PS Archiving Tables View |
| SELECT PSARCH_ID , recname , hist_recname , PSARCH_ROW_COPY , parentrecname FROM PS_ARCH_TBL |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PSARCH_ID |
Character(8) | VARCHAR2(8) NOT NULL | Archive ID (see PSARCHTEMPLATE). |
| 2 | RECNAME |
Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: RECDEFN_VW |
| 3 | HIST_RECNAME |
Character(15) | VARCHAR2(15) NOT NULL | Record (Table) Name |
| 4 | PSARCH_ROW_COPY | Character(1) | VARCHAR2(1) NOT NULL | Copy Parent Criteria |
| 5 | PARENTRECNAME | Character(15) | VARCHAR2(15) NOT NULL | Parent Record Name |