| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
HCR_PERSON_I
|
| 2 |
SCC_1YR_HE_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
First Year Higher Education
Prompt Table:
TERM_YR1_VW
|
| 3 |
SCC_REGIME_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Regime
P=Achievement
T=Tempo
|
| 4 |
SCC_1YR_FINAID_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
First Year Financial Aid
Prompt Table:
TERM_YR1_VW
|
| 5 |
SAD_GBA_STATUS_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
GBA Status
0=Not Verified
1=Reliable upon Verification
2=Unreliable upon Verification
3=Valid GBA relation & address
4=In process of Verification
5=Reliable upon Documentation
6=Emigration
7=Departmental decision
8=Unknown 2
9=Not Applicable
|
| 6 |
SAD_GBA_B_YR_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
GBA Year of Birth
|
| 7 |
SAD_GBA_B_MN_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
GBA Month of Birth
|
| 8 |
SSR_SL_REAS_CD_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Reason Code
Prompt Table:
SSR_SL_RSNC_NLD
|
| 9 |
SSR_SL_CONSENT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Consent Statement
J=Yes
N=No
X=Unknown
Default Value: X
|
| 10 |
SSR_SL_V_STAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
ID Verification Status
A=Dont allow local Verification
D=Locally (institution) verified
E=Not Verified by Institution
F=Locally verified by IB-G
G=IB-G/GBA Verified
I=IB-G/GBA checking in progress
K=IB-G/GBA found in CIOP w/o GBA
L=IB-G/GBA found in CIOP w/ data
O=Unknown
Default Value: E
|
| 11 |
SSR_SL_V_DATE_NLD |
Date(10) |
DATE |
ID Verification Date
Default Value: %DATE
|
| 12 |
SSR_SL_IDPROOF_NLD |
Character(30) |
VARCHAR2(30) NOT NULL |
Identification Document
|
| 13 |
SSR_SL_ID_NBR_NLD |
Character(15) |
VARCHAR2(15) NOT NULL |
Identification Number
|
| 14 |
SSR_SL_V_CODE_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
ID Verified by Brincode
Prompt Table:
SCC_BRINCD_VW
|
| 15 |
SSR_SL_V_USER_NLD |
Character(35) |
VARCHAR2(35) NOT NULL |
ID Verified by User
|
| 16 |
SSR_SL_V_REM_NLD |
Long Character(1000) |
VARCHAR2(1000) |
ID Verification Remark
|
| 17 |
SSR_SL_LOCVERF_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Local Verification Accepted
F=False
T=True
|
| 18 |
SSR_SL_UKN_BD_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Unknown Birthdate
F=False
T=True
|
| 19 |
SSR_SL_PERSDAT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Deliverpersondataagreed
F=False
T=True
|
| 20 |
SSR_SL_RGTRMDT_NLD |
Date(10) |
DATE |
Registration Termination Date
|
| 21 |
LANG_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
CFR=Canadian French
DAN=Danish
DUT=Dutch
ENG=English
ESP=Spanish
FRA=French
GER=German
GRK=Greek
INE=International English
ITA=Italian
JPN=Japanese
KOR=Korean
POR=Portuguese
SVE=Swedish
THA=Thai
ZHS=Simplified Chinese
ZHT=Traditional Chinese
Default Value: DUT
|
| 22 |
SAD_SL_DIGID_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
DIGID Authentication Active
Y/N Table Edit
|
| 23 |
SCC_ROW_ADD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Created By
|
| 24 |
SCC_ROW_ADD_DTTM |
DateTime(26) |
TIMESTAMP |
Created
|
| 25 |
SCC_ROW_UPD_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Updated By
|
| 26 |
SCC_ROW_UPD_DTTM |
DateTime(26) |
TIMESTAMP |
Last Update Date/Time
|