SSR_BR_MERL_ATR

(SQL Table)
Index Back

Enrollment Mirror Staging 2

/* 2021-10-06: fix for Bug-ID: 32929597 - RIOv3 */

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SSR_BR_ENRL_SQ_NLD Character(20) VARCHAR2(20) NOT NULL 2020-04-15 bug 31180485 - enlarged enrollment seq nbr
3 SSR_BR_ENR_ST_DT Date(10) DATE NOT NULL Start Date
4 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: RECDEFN_VW

5 SCC_CAF_ATTRIB_NM Character(20) VARCHAR2(20) NOT NULL Common Attribute

Prompt Table: SSR_BR_ATRNM_VW

6 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
7 SCC_CAF_ATTR_VAL Character(20) VARCHAR2(20) NOT NULL Attribute Value
8 SCC_CAF_ATTR_NVAL Number(32,11) DECIMAL(31,11) NOT NULL Numeric Value
9 SCC_CAF_ATTR_DVAL Date(10) DATE Date Value
10 SCC_CAF_ATTR_TVAL Character(50) VARCHAR2(50) NOT NULL Text Value
11 SCC_CAF_ATTR_TIME Time(15) TIMESTAMP Time Value
12 SCC_CAF_ATTR_YNO Character(1) VARCHAR2(1) NOT NULL Yes/No Value

Y/N Table Edit

13 SCC_CAF_ATTR_LVAL Long Character CLOB Long Text Value
14 SSR_BR_XMLTAG_NLD Character(50) VARCHAR2(50) NOT NULL XML node
15 SSR_BR_FIELDVL_NLD Character(254) VARCHAR2(254) NOT NULL /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */
16 SSR_BR_XMLVL_NLD Long Character CLOB /* 2021-10-13: fix for Bug-ID: 32929597 - RIOv3 */ Converted to long.