PSARCH_IDRECNAMEPSARCH_PROCESSD=Archive Delete
H=Remove from History
I=Import Process
P=Run Reports
R=Archive Rollback
S=Archive Selection
N=System Generated
P=PeopleSoft Delivered
Y=User Modified
Default Value: N
ARCH_SQL_LNG(SQL Table) |
Index Back |
|---|
| # | 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). |
| 3 | PSARCH_PROCESS |
Character(1) | VARCHAR2(1) NOT NULL |
Archive Process
D=Archive Delete H=Remove from History I=Import Process P=Run Reports R=Archive Rollback S=Archive Selection |
| 4 | PSARCH_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Archive Flag
N=System Generated P=PeopleSoft Delivered Y=User Modified Default Value: N |
| 5 | ARCH_LONG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Arch Long Flag |
| 6 | ARCH_SQL | Long Character | CLOB | Generated SQL Statement |