EOEW_ARC_DFN (SQL Table)	Index Back
Archive Map Definition Used to archive or replicate a tables contents, and retrieve the data at some point in the future. The engine that Programs that use AE Program EOEW_ETL_ARC(RunCntl=), or Method ArchiveTable(); Either technique will archive a tables structure and contents. In order to save (and restore) a table, a copy of its structure must be saved, as well as the data itself. This is accomplished by simply saving the ETL meta-data for later use. There are two new records that contain the structure: EOEW_ARC_DFN and EOEW_ARC_FLST. The actual data is stored in a dynamically created table named PS_ARC_. In addition to this data, a new map is created for each archive (or restore), called ARC_. And, a new EOEW_RUN_CNTL is created for each Archive (or restore). AE Program EOEW_ETL_RST(RunCntl=), or Method RestoreTable(); When a table is restored, the current and archived structures are considered, as well as the archived version are taken into account. If a field is added or deleted in the interim, it will be handled automatically. Default values will be used for any added fields.

EOEW_ARC_DFN

(SQL Table)

Archive Map Definition

Used to archive or replicate a tables contents, and retrieve the data at some point in the future. The engine that Programs that use AE Program EOEW_ETL_ARC(RunCntl=), or Method ArchiveTable(); Either technique will archive a tables structure and contents. In order to save (and restore) a table, a copy of its structure must be saved, as well as the data itself. This is accomplished by simply saving the ETL meta-data for later use. There are two new records that contain the structure: EOEW_ARC_DFN and EOEW_ARC_FLST. The actual data is stored in a dynamically created table named PS_ARC_. In addition to this data, a new map is created for each archive (or restore), called ARC_. And, a new EOEW_RUN_CNTL is created for each Archive (or restore). AE Program EOEW_ETL_RST(RunCntl=), or Method RestoreTable(); When a table is restored, the current and archived structures are considered, as well as the archived version are taken into account. If a field is added or deleted in the interim, it will be handled automatically. Default values will be used for any added fields.

Related Language Record: EOEW_ARC_DFNLNG

Parent Record Of EOEW_ARC_FLST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOEW_MAP_OBJ Character(15) VARCHAR2(15) NOT NULL Map Object

2 EOEW_SRC_OBJ Character(30) VARCHAR2(30) NOT NULL Source Object

3 EOEW_TAR_OBJ Character(15) VARCHAR2(15) NOT NULL Target Object
Prompt Table: PSRECDEFN

4 EOEW_SRC_TYP Character(1) VARCHAR2(1) NOT NULL Source Type
0=Reserved
1=Record
2=Data Object
Default Value: 1

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

6 EOEW_ERR_OPT Character(1) VARCHAR2(1) NOT NULL Error Handling Options
0=No Error Handling Needed
1=Identify Error Row
2=Correct data error & reprocess
Default Value: 0

7 EOEW_OBJ_OWNER Character(15) VARCHAR2(15) NOT NULL Subject Area
Default Value: EOEW_OBJ_OWNER.EOEW_OBJ_OWNER
Prompt Table: EOEW_OBJ_OWNER

8 EOEW_ERR_OBJ Character(15) VARCHAR2(15) NOT NULL Error Object
Prompt Table: PSRECDEFN

9 EOEW_ERR_FLD Character(18) VARCHAR2(18) NOT NULL Error Fieldname
Prompt Table: EOEW_TFLDLST_VW

10 EOEW_DUP_OPT Character(1) VARCHAR2(1) NOT NULL Handling of duplicate rows If no error option EOEW_ERR_OPT="0", by defaults, then all duplicates will go to the target, EOEW_DUP_OPT ="0". If error option EOEW_ERR_OPT="1", (identify error), then EOEW_DUP_OPT may be "1" or "6" 1 - Identify duplicates as error rows (go to target table) 6 - Delete all duplicates If error option ="2", (error table provided), then EOEW_DUP_OPT can may be "1","2","3" or "6" 1 - Identify duplicates as error rows (go to error table) 2 - Select first duplicate row from each group (order by not implemented yet) 3 - Select last duplicate row from each group (order by not implemented yet) 6 - Delete all duplicates
0=Copy duplicate rows to target
1=Copy Duplicates to Error Table
2=Copy first row to Target
3=Copy last row to Target
4=Aggregate duplicate row
5=User Defined Function
6=Reject all duplicate rows
Default Value: 0

11 EOEW_LOADDTTM_FLD Character(30) VARCHAR2(30) NOT NULL Load Date Time Fieldname

12 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.
Default Value: EOEW_OPTIONS.MESSAGE_SET_NBR

13 EOEW_AUTOMAP_SW Character(1) VARCHAR2(1) NOT NULL AutoMap
Y/N Table Edit
Default Value: N

14 EOEW_NO_TEMP_SW Character(1) VARCHAR2(1) NOT NULL Direct to Target
Y/N Table Edit
Default Value: N

15 EOEW_KEEP_TMP Character(1) VARCHAR2(1) NOT NULL Retain Temporary Table
Y/N Table Edit
Default Value: N

16 EOEW_MAP_STATUS Character(1) VARCHAR2(1) NOT NULL Used to identify the current map lifecycle stage.
0=Initial
1=Auto-mapper Run
2=Valid
3=Invalid
4=Published
5=Un-Published
6=Locked
Default Value: 0

17 DDLSPACENAME Character(30) VARCHAR2(30) NOT NULL Tablespace Name
Default Value: EOEW_OPTIONS.DDLSPACENAME

18 EOEW_CREATETBL Character(1) VARCHAR2(1) NOT NULL Create Table Dynamically
Y/N Table Edit
Default Value: EOEW_OPTIONS.EOEW_CREATETBL

19 EOEW_RECNAME_TMP Character(15) VARCHAR2(15) NOT NULL Temporary Record (Table)
Prompt Table: PSRECDEFN

20 EOEW_ROW_SOURCE Character(1) VARCHAR2(1) NOT NULL Use row processing for source
Y/N Table Edit
Default Value: N

21 EOEW_ROW_TARGET Character(1) VARCHAR2(1) NOT NULL Use row processing for target
Y/N Table Edit
Default Value: N

22 EOEW_FREEZE_MAP Character(1) VARCHAR2(1) NOT NULL Lock map definition
Y/N Table Edit
Default Value: N

23 EOEW_ARCHIVE_SW Character(1) VARCHAR2(1) NOT NULL Archive
Y/N Table Edit
Default Value: N

24 EOEW_RESTORE_SW Character(1) VARCHAR2(1) NOT NULL Restore Archive
Y/N Table Edit
Default Value: N

25 EOEW_TRUNCATE_SW Character(1) VARCHAR2(1) NOT NULL Destructive Load

26 CREATEDTTM DateTime(26) TIMESTAMP NOT NULL DateTime of Query Creation
Default Value: %datetime

27 LASTUPDDTTM DateTime(26) TIMESTAMP NOT NULL 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.
Default Value: %datetime

28 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.

29 DESCRLONG Long Character CLOB Long Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOEW_MAP_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Map Object
2	EOEW_SRC_OBJ	Character(30)	VARCHAR2(30) NOT NULL	Source Object
3	EOEW_TAR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Target Object Prompt Table: PSRECDEFN
4	EOEW_SRC_TYP	Character(1)	VARCHAR2(1) NOT NULL	Source Type 0=Reserved 1=Record 2=Data Object Default Value: 1
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	EOEW_ERR_OPT	Character(1)	VARCHAR2(1) NOT NULL	Error Handling Options 0=No Error Handling Needed 1=Identify Error Row 2=Correct data error & reprocess Default Value: 0
7	EOEW_OBJ_OWNER	Character(15)	VARCHAR2(15) NOT NULL	Subject Area Default Value: EOEW_OBJ_OWNER.EOEW_OBJ_OWNER Prompt Table: EOEW_OBJ_OWNER
8	EOEW_ERR_OBJ	Character(15)	VARCHAR2(15) NOT NULL	Error Object Prompt Table: PSRECDEFN
9	EOEW_ERR_FLD	Character(18)	VARCHAR2(18) NOT NULL	Error Fieldname Prompt Table: EOEW_TFLDLST_VW
10	EOEW_DUP_OPT	Character(1)	VARCHAR2(1) NOT NULL	Handling of duplicate rows If no error option EOEW_ERR_OPT="0", by defaults, then all duplicates will go to the target, EOEW_DUP_OPT ="0". If error option EOEW_ERR_OPT="1", (identify error), then EOEW_DUP_OPT may be "1" or "6" 1 - Identify duplicates as error rows (go to target table) 6 - Delete all duplicates If error option ="2", (error table provided), then EOEW_DUP_OPT can may be "1","2","3" or "6" 1 - Identify duplicates as error rows (go to error table) 2 - Select first duplicate row from each group (order by not implemented yet) 3 - Select last duplicate row from each group (order by not implemented yet) 6 - Delete all duplicates 0=Copy duplicate rows to target 1=Copy Duplicates to Error Table 2=Copy first row to Target 3=Copy last row to Target 4=Aggregate duplicate row 5=User Defined Function 6=Reject all duplicate rows Default Value: 0
11	EOEW_LOADDTTM_FLD	Character(30)	VARCHAR2(30) NOT NULL	Load Date Time Fieldname
12	MESSAGE_SET_NBR	Number(5,0)	INTEGER NOT NULL	Message Set Number. This field refers to the Message Set Number in the Message Catalog. Default Value: EOEW_OPTIONS.MESSAGE_SET_NBR
13	EOEW_AUTOMAP_SW	Character(1)	VARCHAR2(1) NOT NULL	AutoMap Y/N Table Edit Default Value: N
14	EOEW_NO_TEMP_SW	Character(1)	VARCHAR2(1) NOT NULL	Direct to Target Y/N Table Edit Default Value: N
15	EOEW_KEEP_TMP	Character(1)	VARCHAR2(1) NOT NULL	Retain Temporary Table Y/N Table Edit Default Value: N
16	EOEW_MAP_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Used to identify the current map lifecycle stage. 0=Initial 1=Auto-mapper Run 2=Valid 3=Invalid 4=Published 5=Un-Published 6=Locked Default Value: 0
17	DDLSPACENAME	Character(30)	VARCHAR2(30) NOT NULL	Tablespace Name Default Value: EOEW_OPTIONS.DDLSPACENAME
18	EOEW_CREATETBL	Character(1)	VARCHAR2(1) NOT NULL	Create Table Dynamically Y/N Table Edit Default Value: EOEW_OPTIONS.EOEW_CREATETBL
19	EOEW_RECNAME_TMP	Character(15)	VARCHAR2(15) NOT NULL	Temporary Record (Table) Prompt Table: PSRECDEFN
20	EOEW_ROW_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for source Y/N Table Edit Default Value: N
21	EOEW_ROW_TARGET	Character(1)	VARCHAR2(1) NOT NULL	Use row processing for target Y/N Table Edit Default Value: N
22	EOEW_FREEZE_MAP	Character(1)	VARCHAR2(1) NOT NULL	Lock map definition Y/N Table Edit Default Value: N
23	EOEW_ARCHIVE_SW	Character(1)	VARCHAR2(1) NOT NULL	Archive Y/N Table Edit Default Value: N
24	EOEW_RESTORE_SW	Character(1)	VARCHAR2(1) NOT NULL	Restore Archive Y/N Table Edit Default Value: N
25	EOEW_TRUNCATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Destructive Load
26	CREATEDTTM	DateTime(26)	TIMESTAMP NOT NULL	DateTime of Query Creation Default Value: %datetime
27	LASTUPDDTTM	DateTime(26)	TIMESTAMP NOT NULL	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. Default Value: %datetime
28	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.
29	DESCRLONG	Long Character	CLOB	Long Description