ARCH_PROJ (SQL Table)	Index Back
PS Archiving Projects

ARCH_PROJ

(SQL Table)

PS Archiving Projects

Parent Record Of ARCH_TBL PSARCHRSTQRY_VW PSARCHSELQRY_VW PSARCHTEMPAE PSARCHTEMPOBJ PSARCHTEMPQRY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 DESCR Character(30) VARCHAR2(30) NOT NULL Description

3 ARCH_FLAT_FILE Character(1) VARCHAR2(1) NOT NULL Archive to Flat File?
Y/N Table Edit
Default Value: N

4 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference

5 LASTUPDDTTM 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.

6 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
3	ARCH_FLAT_FILE	Character(1)	VARCHAR2(1) NOT NULL	Archive to Flat File? Y/N Table Edit Default Value: N
4	VERSION	Number(10,0)	DECIMAL(10) NOT NULL	Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
5	LASTUPDDTTM	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.
6	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.