ARCH_PRIORTY_VW (SQL View)	Index Back
Prioritizing Opt Tbl View Prioritize the order of tables to be process. Used in Archiving directly to flat file process.

ARCH_PRIORTY_VW

(SQL View)

Prioritizing Opt Tbl View

Prioritize the order of tables to be process. Used in Archiving directly to flat file process.

SELECT PSARCH_ID , recname , PSARCH_PRIORITY FROM PS_ARCH_FLT_OPT

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).
Prompt Table: ARCH_PROJ

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

3 PSARCH_PRIORITY Number(3,0) SMALLINT NOT NULL Archiving Priority

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE). Prompt Table: ARCH_PROJ
2	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
3	PSARCH_PRIORITY	Number(3,0)	SMALLINT NOT NULL	Archiving Priority