SCC_USI_RQDT_VW

(SQL View)
 Index Back

SELECT EMPLID ,SCC_USI_SUB_DTTM , SCC_USI_RETR_DTTM , SCC_USI_SEL_OPT , SCC_USI_REQST_ID , SCC_USI_APPLN_ID , OPRID , SCC_USI_RESULT , SCC_USI_STATUS , SCC_USI_FNAME_MTCH , SCC_USI_FMYNM_MTCH , SCC_USI_SNGNM_MTCH , SCC_USI_DOB_MTCH , SCC_USI_ERROR_CD , SCC_USI_ERR_MSG , SCC_ROW_ADD_OPRID , SCC_ROW_ADD_DTTM , SCC_ROW_UPD_OPRID , SCC_ROW_UPD_DTTM FROM PS_SCC_USI_REQUEST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 SCC_USI_SUB_DTTM DateTime(26) TIMESTAMP Submit Date/Time
3 SCC_USI_RETR_DTTM DateTime(26) TIMESTAMP Retrieve Date/Time
4 SCC_USI_SEL_OPT Character(1) VARCHAR2(1) NOT NULL USI Select Option
C=Create USI
E=Enter USI

Default Value: E

5 SCC_USI_REQST_ID Number(8,0) INTEGER NOT NULL USI Request ID
6 SCC_USI_APPLN_ID Number(6,0) INTEGER NOT NULL USI Application ID
7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
8 SCC_USI_RESULT Character(1) VARCHAR2(1) NOT NULL USI Result
F=Failure
M=Match Found
S=Success
9 SCC_USI_STATUS Character(1) VARCHAR2(1) NOT NULL USI Status
D=Deactivated
I=Invalid
V=Valid
10 SCC_USI_FNAME_MTCH Character(1) VARCHAR2(1) NOT NULL First Name Match
N=No Match
Y=Match
11 SCC_USI_FMYNM_MTCH Character(1) VARCHAR2(1) NOT NULL Family Name Match
N=No Match
Y=Match
12 SCC_USI_SNGNM_MTCH Character(1) VARCHAR2(1) NOT NULL Single Name Match
N=No Match
Y=Match
13 SCC_USI_DOB_MTCH Character(1) VARCHAR2(1) NOT NULL Birth Date Match
N=No Match
Y=Match
14 SCC_USI_ERROR_CD Character(4) VARCHAR2(4) NOT NULL USI Error Code
15 SCC_USI_ERR_MSG Character(254) VARCHAR2(254) NOT NULL USI Error Message
16 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
17 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
18 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
19 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time