DP_ARCH_INFO (SQL Table)	Index Back
DP Archive Information DP Archive Information

DP_ARCH_INFO

(SQL Table)

DP Archive Information

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

2 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID

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

4 DP_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_CONFIGVIEW
Prompt Table: DP_ARCH_CON_VW

5 DP_ARCH_CONFIGVIEW Character(20) VARCHAR2(20) NOT NULL DP_ARCH_CONFIGVIEW
Prompt Table: DP_ARCH_CON2_VW

6 DESCRLONG Long Character CLOB Long Description

7 DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
3	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE). Prompt Table: ARCH_PROJ
4	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW Prompt Table: DP_ARCH_CON_VW
5	DP_ARCH_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_ARCH_CONFIGVIEW Prompt Table: DP_ARCH_CON2_VW
6	DESCRLONG	Long Character	CLOB	Long Description
7	DTTM_STAMP	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.