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 |