SCC_USI_REQUEST

(SQL Table)
 Index Back

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

Prompt Table: SCC_PERS_SA_VW

2 SCC_USI_SUB_DTTM DateTime(26) TIMESTAMP Submit Date/Time

Default Value: %datetime

3 SCC_USI Character(10) VARCHAR2(10) NOT NULL Unique Student Identifier
4 SCC_USI_CNTRY Character(100) VARCHAR2(100) NOT NULL USI Country

Prompt Table: SCC_USI_MAP_VW

5 SCC_USI_CNTRY_IN Character(3) VARCHAR2(3) NOT NULL Country Studying In

Prompt Table: COUNTRY_TBL

6 SCC_USI_SEL_OPT Character(1) VARCHAR2(1) NOT NULL USI Select Option
C=Create USI
E=Enter USI

Default Value: E

7 SCC_USI_PRCS_NOW Character(1) VARCHAR2(1) NOT NULL USI Processing
N=Batch
Y=Live
8 SCC_USI_FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
9 SCC_USI_LAST_NAME Character(30) VARCHAR2(30) NOT NULL Family Name
10 SCC_USI_SINGLE_NM Character(30) VARCHAR2(30) NOT NULL Single Name
11 SCC_USI_BIRTHDATE Date(10) DATE Date of Birth
12 SCC_USI_PREF_CNT Character(1) VARCHAR2(1) NOT NULL Preferred Contact Mode
E=Email
M=Mail
S=SMS

Default Value: E

13 SCC_USI_DVS_REQ Character(1) VARCHAR2(1) NOT NULL Verfification Required
N=No
Y=Yes
14 SCC_USI_DVS_TYP Character(1) VARCHAR2(1) NOT NULL Evidence of Identity
B=Birth Certificate
C=Citizenship Certificate
D=Driver's License
K=Medicare
P=Passport
R=Registration by Descent
V=Visa

Default Value: D

15 SCC_USI_REG_NBR Character(12) VARCHAR2(12) NOT NULL Registration Number
16 SCC_USI_REG_ST Character(3) VARCHAR2(3) NOT NULL Registration State

Prompt Table: HCR_STONLY_I

17 SCC_USI_REG_DT Date(10) DATE Registration Date
18 SCC_USI_REG_YR Number(4,0) SMALLINT NOT NULL Registration Year
19 SCC_USI_DT_PRT Date(10) DATE Date Printed
20 SCC_USI_CERT_NBR Character(11) VARCHAR2(11) NOT NULL Certificate Number
21 SCC_USI_STOCK_NBR Character(11) VARCHAR2(11) NOT NULL Stock Number
22 SCC_USI_ACQ_DT Date(10) DATE Acquisition Date
23 SCC_USI_FRST_NM Character(60) VARCHAR2(60) NOT NULL Previous First Name
24 SCC_USI_FMLY_NM Character(50) VARCHAR2(50) NOT NULL Previous Family Name
25 SCC_USI_LIC_NBR Character(10) VARCHAR2(10) NOT NULL Licence Number
26 SCC_USI_STATE Character(3) VARCHAR2(3) NOT NULL State

Prompt Table: HCR_STONLY_I

27 SCC_USI_MRG_DT Date(10) DATE Marriage Date
28 SCC_USI_GRM_CHK Character(1) VARCHAR2(1) NOT NULL Is Applicant Groom
N=No
Y=Yes
29 SCC_USI_MCRD_NBR Character(10) VARCHAR2(10) NOT NULL Medicare Card Number
30 SCC_USI_REF_NBR Number(1,0) SMALLINT NOT NULL Individual Reference Number

Default Value: 0

31 SCC_USI_EXP_DT Date(10) DATE Expiry Date
32 SCC_USI_CARD_CLR Character(1) VARCHAR2(1) NOT NULL Medicare Card Colour
B=Blue
G=Green
Y=Yellow
33 SCC_USI_NM_LN1 Character(27) VARCHAR2(27) NOT NULL NameLine 1
34 SCC_USI_NM_LN2 Character(25) VARCHAR2(25) NOT NULL NameLine 2
35 SCC_USI_NM_LN3 Character(23) VARCHAR2(23) NOT NULL NameLine 3
36 SCC_USI_NM_LN4 Character(21) VARCHAR2(21) NOT NULL NameLine 4
37 SCC_USI_DOC_NBR Character(9) VARCHAR2(9) NOT NULL Passport Document Number
38 SCC_USI_PSPT_NBR Character(14) VARCHAR2(14) NOT NULL Passport Number
39 SCC_USI_VISA_CNTRY Character(100) VARCHAR2(100) NOT NULL VISA Country

Prompt Table: SCC_USI_VISA_VW

40 SCC_USI_CNTRY_ISS Character(3) VARCHAR2(3) NOT NULL Country of Issue
41 SCC_USI_RETR_DTTM DateTime(26) TIMESTAMP Retrieve Date/Time
42 SCC_USI_REQST_ID Number(8,0) INTEGER NOT NULL USI Request ID
43 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
44 SCC_USI_APPLN_ID Number(6,0) INTEGER NOT NULL USI Application ID
45 SCC_USI_RESULT Character(1) VARCHAR2(1) NOT NULL USI Result
F=Failure
M=Match Found
S=Success
46 SCC_USI_DVS_CHK Character(1) VARCHAR2(1) NOT NULL Identity Verified
F=False
N=Not Verified
T=True
47 SCC_USI_ERROR_CD Character(4) VARCHAR2(4) NOT NULL USI Error Code
48 SCC_USI_ERR_MSG Character(254) VARCHAR2(254) NOT NULL USI Error Message
49 SCC_USI_STATUS Character(1) VARCHAR2(1) NOT NULL USI Status
D=Deactivated
I=Invalid
V=Valid
50 SCC_USI_FNAME_MTCH Character(1) VARCHAR2(1) NOT NULL First Name Match
N=No Match
Y=Match
51 SCC_USI_FMYNM_MTCH Character(1) VARCHAR2(1) NOT NULL Family Name Match
N=No Match
Y=Match
52 SCC_USI_SNGNM_MTCH Character(1) VARCHAR2(1) NOT NULL Single Name Match
N=No Match
Y=Match
53 SCC_USI_DOB_MTCH Character(1) VARCHAR2(1) NOT NULL Birth Date Match
N=No Match
Y=Match
54 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
55 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
56 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
57 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time