GPFR_DA_DAT_LOG

(SQL Table)
 Index Back

DADS related record for Log

DADS related record: created in order to store the extracted records (with values) in the structures during the DADS process plus the process instance and a message set and number.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPFR_DA_SNDREF Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: GPFR_DA_SNDREF

2 GPFR_DA_RECIP Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: GPFR_DA_RECIP

3 GPFR_DA_COMPANY Character(3) VARCHAR2(3) NOT NULL DADS related field

Prompt Table: COMPANY_TBL

4 GPFR_DA_EMPLID Character(16) VARCHAR2(16) NOT NULL DADS related field
5 GPFR_DA_BGNDT Date(10) DATE DADS related field
6 GPFR_DA_ENDDT Date(10) DATE DADSD related field
7 GPFR_DA_FEEREF Character(20) VARCHAR2(20) NOT NULL DADS related field
8 GPFR_DA_ESTAB Character(12) VARCHAR2(12) NOT NULL DADS related field

Prompt Table: ESTAB_TBL

9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
10 GPFR_DA_ST_NUM Number(10,0) DECIMAL(10) NOT NULL DADS related field
11 GPFR_DA_REC_NUM Number(5,0) INTEGER NOT NULL DADS related field
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.
13 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.
14 GPFR_DA_STRUCT Character(10) VARCHAR2(10) NOT NULL DADS related field
15 GPFR_DA_RECORD Character(10) VARCHAR2(10) NOT NULL DADS related record

Prompt Table: GPFR_DA_REC_VW

16 GPFR_DA_CODE Character(10) VARCHAR2(10) NOT NULL DADS related field

Prompt Table: %RECNAME_EDIT

17 GPFR_DA_NUM_VALUE Signed Number(20,6) DECIMAL(18,6) NOT NULL DADS related field
18 GPFR_DA_CHR_VALUE Character(120) VARCHAR2(120) NOT NULL DADS related field
19 GPFR_DA_ACTION Character(1) VARCHAR2(1) NOT NULL DADS related field
1=Override
2=Add

Default Value: 1

20 LAST_UPDT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Updated User Name
21 LAST_UPDT_DTTM DateTime(26) TIMESTAMP Last Updated Date-Time Stamp
22 GPFR_DA_DATST Character(1) VARCHAR2(1) NOT NULL DADS related field
A=Added
E=Extracted
I=Ignored
P=Pending
U=Updated

Default Value: A

23 GPFR_DA_STATUS Character(1) VARCHAR2(1) NOT NULL DADS related field
A=Active
I=Inactive

Default Value: A

24 GPFR_DA_VAL_STATUS Character(1) VARCHAR2(1) NOT NULL Status of the Log info.
E=Error
I=Ignore
N=Not Checked
P=Pending
V=Valid
W=Warning
25 USER_KEY1 Character(25) VARCHAR2(25) NOT NULL User Key 1
26 USER_KEY2 Character(25) VARCHAR2(25) NOT NULL User Key 2
27 USER_KEY3 Character(25) VARCHAR2(25) NOT NULL User Key 3
28 USER_KEY4 Character(25) VARCHAR2(25) NOT NULL User Key 4
29 USER_KEY5 Character(25) VARCHAR2(25) NOT NULL User Key 5
30 USER_KEY6 Character(25) VARCHAR2(25) NOT NULL User Key 6