| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 SCC_TEMP_ID |
Number(16,0) |
DECIMAL(16) NOT NULL |
Temp Constituent ID
|
| 2 |
SSR_PRIOR_EDU_NLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Prior Education
Prompt Table:
SSR_PRE_EDU_NLD
|
| 3 |
END_DT |
Date(10) |
DATE |
end date
|
| 4 |
PROGRAM_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Program Status
C=Completed
F=Failed
R=Running
|
| 5 |
SSR_HGH_PR_EDU_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Highest form of Education
Y/N Table Edit
Default Value: N
|
| 6 |
EXT_ORG_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
External Org ID
Prompt Table:
EXT_ORG_SCH_VW
|
| 7 |
SSR_CLUST_ID_NLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Cluster Code
Prompt Table:
SSR_CLUSTER_NLD
|
| 8 |
SSR_SL_PR_EXT_NLD |
Character(5) |
VARCHAR2(5) NOT NULL |
Prior Ed Extension Number
|
| 9 |
SSR_SL_PR_DSC2_NLD |
Character(100) |
VARCHAR2(100) NOT NULL |
Prior Ed Extension Desc
|
| 10 |
SSR_SL_PR_CNTY_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Prior Ed Extension Country
Prompt Table:
SSR_COUNTRY_NLD
|
| 11 |
SSR_SL_DIPLOMA_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Diploma Indicator
F=False
T=True
Default Value: F
|
| 12 |
SSR_SL_PR_VERF_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
Prior Ed Verified Status
A=Institute verification removed
DD=Decentralized diploma
GD=Centralized Diploma
GV=Verified, diploma unverified
ID=Diploma verified by IBG
N=Not Verified
NG=Not verified in time allowed
NT=Not verified, no consent given
NV=Not verified, no IBG data
NX=Not verified, unknown consent
|
| 13 |
SSR_SL_LOCVERF_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Local Verification Accepted
F=False
T=True
|
| 14 |
SSR_SL_PR_V_DT_NLD |
Date(10) |
DATE |
Prior Ed Verification Date
|
| 15 |
SSR_SL_PR_V_CD_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Prior Ed Verified by Brincode
Prompt Table:
SCC_BRINCD_NLD
|
| 16 |
SSR_SL_PR_V_NM_NLD |
Character(35) |
VARCHAR2(35) NOT NULL |
Prior Ed Verified by User
|
| 17 |
SSR_SL_CONFIRM_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Data Confirmed
Y/N Table Edit
|
| 18 |
SSR_SL_SUBORG_NLD |
Character(2) |
VARCHAR2(2) NOT NULL |
SubOrganization
Prompt Table:
SCC_SUBBRIN_NLD
|
| 19 |
SSR_SL_VRFACPT_NLD |
Character(1) |
VARCHAR2(1) NOT NULL |
Verification Accepted
F=False
T=True
|
| 20 |
SAD_SL_DIPL_YR_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Diploma Year
|
| 21 |
SAD_SL_MUTDTTM_NLD |
DateTime(26) |
TIMESTAMP |
Mutation Datetime Stamp
|
| 22 |
SAD_SL_MUT_BY_NLD |
Character(4) |
VARCHAR2(4) NOT NULL |
Mutation By
BRON=BRON
FOS=Front Office Student
IBG=IBG
SDB=Studielink Dashboard
SIS=Student System
|
| 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
|