GPFR_DSN_ET_ADT (SQL Table)	Index Back
Event run control-Audit Record Event run control -Audit Record

GPFR_DSN_ET_ADT

(SQL Table)

Event run control-Audit Record

Event run control -Audit Record

# 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 GPFR_DSN_EVT_TYP Character(30) VARCHAR2(30) NOT NULL DSN Event Type

4 GPFR_AF_EXTRACT_ID Character(18) VARCHAR2(18) NOT NULL Application Framework - Extraction ID

5 GPFR_DSN_AF_EVTRUN Character(45) VARCHAR2(45) NOT NULL DSN Event runcontrol id for AF

6 GPFR_AF_EXTRCT_EE Character(50) VARCHAR2(50) NOT NULL Extract ID to execute application framework just to get the list of employees for a DSN event.

7 GPFR_DSN_AF_EESRUN Character(45) VARCHAR2(45) NOT NULL DSN Event employee selection run control id for AF

8 GPFR_DSN_IND_SEL Character(1) VARCHAR2(1) NOT NULL Sending reference select
Y/N Table Edit

9 GPFR_DSN_IND_DEL Character(1) VARCHAR2(1) NOT NULL Sending reference delete
Y/N Table Edit

10 GPFR_DSN_IND_REP Character(1) VARCHAR2(1) NOT NULL Sending reference delete
Y/N Table Edit

11 GPFR_DSN_IND_FIN Character(1) VARCHAR2(1) NOT NULL Sending reference extraction finalized
Y/N Table Edit

12 GPFR_DSN_STATUS Character(1) VARCHAR2(1) NOT NULL DSN run status
E=Extracted
F=Finalized
N=No Extraction

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

#	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	GPFR_DSN_EVT_TYP	Character(30)	VARCHAR2(30) NOT NULL	DSN Event Type
4	GPFR_AF_EXTRACT_ID	Character(18)	VARCHAR2(18) NOT NULL	Application Framework - Extraction ID
5	GPFR_DSN_AF_EVTRUN	Character(45)	VARCHAR2(45) NOT NULL	DSN Event runcontrol id for AF
6	GPFR_AF_EXTRCT_EE	Character(50)	VARCHAR2(50) NOT NULL	Extract ID to execute application framework just to get the list of employees for a DSN event.
7	GPFR_DSN_AF_EESRUN	Character(45)	VARCHAR2(45) NOT NULL	DSN Event employee selection run control id for AF
8	GPFR_DSN_IND_SEL	Character(1)	VARCHAR2(1) NOT NULL	Sending reference select Y/N Table Edit
9	GPFR_DSN_IND_DEL	Character(1)	VARCHAR2(1) NOT NULL	Sending reference delete Y/N Table Edit
10	GPFR_DSN_IND_REP	Character(1)	VARCHAR2(1) NOT NULL	Sending reference delete Y/N Table Edit
11	GPFR_DSN_IND_FIN	Character(1)	VARCHAR2(1) NOT NULL	Sending reference extraction finalized Y/N Table Edit
12	GPFR_DSN_STATUS	Character(1)	VARCHAR2(1) NOT NULL	DSN run status E=Extracted F=Finalized N=No Extraction
13	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.