SSR_HE_VAL_STG

(SQL Table)
Index Back

Staging Tbl for HESA Validate

Staging Table for HESA Validation errors

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SSR_HE_LEVEL Character(10) VARCHAR2(10) NOT NULL Field to hold Column Level value in Validation kit errors
2 SSR_HE_RULE_NUM Character(250) VARCHAR2(250) NOT NULL Field to hold Rule Number column value of validation errors
3 SSR_HE_RULE_DESC Character(250) VARCHAR2(250) NOT NULL Column to hold Rule Description value fo validation Errors
4 SSR_HE_COLUMN1 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN1
5 SSR_HE_COLUMN2 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN2
6 SSR_HE_COLUMN3 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN3
7 SSR_HE_COLUMN4 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN4
8 SSR_HE_COLUMN5 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN5
9 SSR_HE_COLUMN6 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN6
10 SSR_HE_COLUMN7 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN7
11 SSR_HE_COLUMN8 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN8
12 SSR_HE_COLUMN9 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN9
13 SSR_HE_COLUMN10 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN10
14 SSR_HE_COLUMN11 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN11
15 SSR_HE_COLUMN12 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN12
16 SSR_HE_COLUMN13 Character(250) VARCHAR2(250) NOT NULL VALIDATION TABLE COLUMN13
17 SSR_HE_COLUMN14 Character(50) VARCHAR2(50) NOT NULL VALIDATION TABLE COLUMN14
18 SSR_HE_LINE_NUM Character(10) VARCHAR2(10) NOT NULL Field to hold Line Number column value of validation errors