EO_DSPRIOR_VAL

(SQL Table)
 Index Back

Effective Date Delay Msg Table

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 MSGNAME Character(30) VARCHAR2(30) NOT NULL Application Message Name. Name of the Application Message Definition. (see PSMSGDEFN).

Prompt Table: PSMSGDEFN

2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: PSRECDEFN

3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
4 EFFDT Date(10) DATE NOT NULL Effective Date

Default Value: %date

5 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
6 KEY_CHAR_40_01 Character(40) VARCHAR2(40) NOT NULL Key Char 40/01
7 KEY_CHAR_40_02 Character(40) VARCHAR2(40) NOT NULL Key Char 40/02
8 KEY_CHAR_40_03 Character(40) VARCHAR2(40) NOT NULL Key Char 40/03
9 KEY_CHAR_40_04 Character(40) VARCHAR2(40) NOT NULL Key Char 40/04
10 KEY_CHAR_40_05 Character(40) VARCHAR2(40) NOT NULL Key Char 40/05
11 KEY_CHAR_40_06 Character(40) VARCHAR2(40) NOT NULL Key_Char 40/06
12 KEY_CHAR_40_07 Character(40) VARCHAR2(40) NOT NULL Key Char 40/07
13 KEY_CHAR_40_08 Character(40) VARCHAR2(40) NOT NULL Key Char 40/08
14 KEY_CHAR_40_09 Character(40) VARCHAR2(40) NOT NULL Key Char 40/09
15 KEY_CHAR_40_10 Character(40) VARCHAR2(40) NOT NULL Key Char 40/10
16 IN_PROCESS_FLG Character(1) VARCHAR2(1) NOT NULL In Process
17 KEYCOUNT Number(3,0) SMALLINT NOT NULL Number of Keys
18 KEY_FIELD_NAME_01 Character(18) VARCHAR2(18) NOT NULL Key Field Name 01 storing the table column name for the first key
19 KEY_FIELD_NAME_02 Character(18) VARCHAR2(18) NOT NULL Key Field Name 02 storing the table column name for key position number two.
20 KEY_FIELD_NAME_03 Character(18) VARCHAR2(18) NOT NULL Key Field Name 03 storing the table column name for key position number three.
21 KEY_FIELD_NAME_04 Character(18) VARCHAR2(18) NOT NULL Key Field Name 04 storing the table column name for key position number four.
22 KEY_FIELD_NAME_05 Character(18) VARCHAR2(18) NOT NULL Key Field Name 05 storing the table column name for key position number five.
23 KEY_FIELD_NAME_06 Character(18) VARCHAR2(18) NOT NULL Key Field Name 06 storing the table column name for key position number six.
24 KEY_FIELD_NAME_07 Character(18) VARCHAR2(18) NOT NULL Key Field Name 07 storing the table column name for key position number seven.
25 KEY_FIELD_NAME_08 Character(18) VARCHAR2(18) NOT NULL Key Field Name 01 storing the table column name for the first key
26 KEY_FIELD_NAME_09 Character(18) VARCHAR2(18) NOT NULL Key Field Name 01 storing the table column name for the first key
27 KEY_FIELD_NAME_10 Character(18) VARCHAR2(18) NOT NULL Key Field Name 01 storing the table column name for the first key
28 AUDIT_ACTN Character(1) VARCHAR2(1) NOT NULL Audit Action Code for Application Messages. This tells the subscriber whether the row has been added, changed, or deleted.
A=Add
C=Change Old (PPR Only)
D=Delete
K=Change - Old Values
N=Change - New Values
O=Change - Original Values
29 DSXMLMSG Long Character CLOB XML Message