TL_RI_TEST_AET

(SQL Table)
Index Back

T&L RI State Record

This Record is used in RI AE Process

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 VALID_DEFN_ID Character(10) VARCHAR2(10) NOT NULL Validation ID
3 PRIMARY_KEY_NAME1 Character(18) VARCHAR2(18) NOT NULL Primary Key Name1
4 PRIMARY_KEY_VALUE1 Character(18) VARCHAR2(18) NOT NULL Primary Key Value1
5 PRIMARY_KEY_NAME2 Character(18) VARCHAR2(18) NOT NULL Primary Key Name2
6 PRIMARY_KEY_VALUE2 Number(3,0) SMALLINT NOT NULL Primary Key Value 2
7 COLUMN_NM Character(18) VARCHAR2(18) NOT NULL Column Name
8 COLUMN_VALUE_CHAR Character(30) VARCHAR2(30) NOT NULL The Column Value (Character) where the RI Instance is created
9 COLUMN_VALUE_NUM Signed Number(20,6) DECIMAL(18,6) NOT NULL Column Value (Numeric)
10 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
11 EFFDT Date(10) DATE Effective Date
12 END_DATE Date(10) DATE End Date
13 OPERATOR_SIGN Character(30) VARCHAR2(30) NOT NULL This Field is used in TL_RI_RESOLV Process
14 STRING_DATE Character(100) VARCHAR2(100) NOT NULL This Field is used in TL_RI_RESOLV Process
15 STRING_DTTM Character(100) VARCHAR2(100) NOT NULL This Field is used in TL_RI_RESOLV Process
16 VALID_INST_ID Number(15,0) DECIMAL(15) NOT NULL Validation Instance
17 SEQUENCENO Number(10,0) DECIMAL(10) NOT NULL Sequence Number
18 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
19 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Rcd Nbr
20 VALID_STREAM_ID Number(15,0) DECIMAL(15) NOT NULL Validation Stream ID
21 TABLE_NAME Character(30) VARCHAR2(30) NOT NULL Table Name
22 START_DT Date(10) DATE Start Date
23 END_DT Date(10) DATE end date
24 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
25 AE_APPLID Character(12) VARCHAR2(12) NOT NULL Program Name (see PSAEAPPLDEFN).
26 AE_SECTION Character(8) VARCHAR2(8) NOT NULL Section