Panel | ||||||
---|---|---|---|---|---|---|
panelIconId | atlassian-info | |||||
panelIcon | :info: | |||||
Panel | ||||||
| ||||||
The tables below pertain to the latest CCCApply Standard & Noncredit Application version. For more information, see CCCApplyRelease Notes& Data Dictionaries. |
...
For field specifications, see the CCCApply Standard & Noncredit Application data dictionary.
Apply: College Adaptor |
---|
CCC Field Name
DB Staging Table
MSQL Field Name
Notes
studentParent
student_parent
SG v.4.7
acceptedTerms
accepted_terms
Element | Apply Data Element | System | Type | Length | MS SQL TABLE | MS SQL FIELD NAME |
---|---|---|---|---|---|---|
raceAIANOtherDescription | race_aian_other_description | SG v.4. |
acceptedTermsTimestamp
accepted_terms_timestamp
10 | Text | 1024 | SZRAPLY | raceAIANOtherDescription |
studentDepsUnder18 | student_deps_under18 | SG v.4. |
ipAddressAtAccountCreation
ip_address_at_account_creation
10 | Single Digit Number | 1 | SZRAPLY | studentDepsUnder18 |
studentDeps18Over | student_deps_18over | SG v.4. |
ipAddressAtAppCreation
ip_address_at_app_creation
10 | Single Digit Number | 1 | SZRAPLY | studentDeps18Over |
idmeConfirmationTimestamp | idme_confirmation_timestamp | SG v.4. |
mailingAddressValidationOverride
mailing_address_validation_override
9 | Date with UTC Time | SZRAPLY | idmeConfirmationTimestamp | |
idmeOptinTimestamp | idme_optin_timestamp | SG v.4. |
phoneType
phone_type
9 | Date with UTC Time | SZRAPLY | idmeOptinTimestamp | |
idmeWorkflowStatus | idme_workflow_status | SG v.4. |
caOutsideVoted
ca_outside_voted
CA_OUTSIDE_VOTED
caOutsideVotedYear
ca_outside_voted_year
CA_OUTSIDE_VOTED_YEAR
caOutsideCollege
ca_outside_college
CA_OUTSIDE_COLLEGE
caOutsideCollegeYear
ca_outside_college_year
CA_OUTSIDE_COLLEGE_YEAR
caOutsideLawsuit
ca_outside_lawsuit
CA_OUTSIDE_LAWSUIT
caOutsideLawsuitYear
ca_outside_lawsuit_year
CA_OUTSIDE_LAWSUIT_YEAR
resStatus
res_status
RES_STATUS
resStatusChange
res_status_change
RES_STATUS_CHANGE
resPrevDate
res_prev_date
RES_PREV_DATE
admIneligible
adm_ineligible
ADM_INELIGIBLE
eligAb540
elig_ab540
ELIG_AB540
resAreaA
res_area_a
RES_AREA_A
resAreaB
res_area_b
RES_AREA_B
resAreaC
res_area_c
RES_AREA_C
resAreaD
res_area_d
RES_AREA_D
experience
experience
EXPERIENCE
recommend
recommend
RECOMMEND
comments
comments
COMMENTS
comfortableEnglish
comfortable_english
COMFORTABLE_ENGLISH
financialAssistance
financial_assistance
FINANCIAL_ASSISTANCE
tanfSsiGa
tanf_ssi_ga
TANF_SSI_GA
fosterYouths
foster_youths
FOSTER_YOUTHS
athleticIntercollegiate
athletic_intercollegiate
ATHLETIC_INTERCOLLEGIATE
athleticIntramural
athletic_intramural
ATHLETIC_INTRAMURAL
athleticNotInterested
athletic_not_interested
ATHLETIC_NOT_INTERESTED
academicCounseling
academic_counseling
ACADEMIC_COUNSELING
basicSkills
basic_skills
BASIC_SKILLS
calworks
calworks
CALWORKS
careerPlanning
career_planning
CAREER_PLANNING
childCare
child_care
CHILD_CARE
counselingPersonal
counseling_personal
COUNSELING_PERSONAL
dsps
dsps
DSPS
eops
eops
EOPS
esl
esl
ESL
healthServices
health_services
HEALTH_SERVICES
housingInfo
housing_info
HOUSING_INFO
employmentAssistance
employment_assistance
EMPLOYMENT_ASSISTANCE
onlineClasses
online_classes
ONLINE_CLASSES
reentryProgram
reentry_program
REENTRY_PROGRAM
scholarshipInfo
scholarship_info
SCHOLARSHIP_INFO
studentGovernment
student_government
STUDENT_GOVERNMENT
testingAssessment
testing_assessment
TESTING_ASSESSMENT
transferInfo
transfer_info
TRANSFER_INFO
tutoringServices
tutoring_services
TUTORING_SERVICES
veteransServices
veterans_services
VETERANS_SERVICES
integrityFg01
integrity_fg_01
INTEGRITY_FG_01
integrityFg02
integrity_fg_02
INTEGRITY_FG_02
integrityFg03
integrity_fg_03
INTEGRITY_FG_03
integrityFg04
integrity_fg_04
INTEGRITY_FG_04
integrityFg11
integrity_fg_11
INTEGRITY_FG_11
integrityFg47
integrity_fg_47
INTEGRITY_FG_47
integrityFg48
integrity_fg_48
INTEGRITY_FG_48
integrityFg49
integrity_fg_49
INTEGRITY_FG_49
integrityFg50
integrity_fg_50
INTEGRITY_FG_50
integrityFg51
integrity_fg_51
INTEGRITY_FG_51
integrityFg52
integrity_fg_52
INTEGRITY_FG_52
integrityFg53
integrity_fg_53
INTEGRITY_FG_53
integrityFg54
integrity_fg_54
INTEGRITY_FG_54
integrityFg55
integrity_fg_55
INTEGRITY_FG_55
integrityFg56
integrity_fg_56
INTEGRITY_FG_56
integrityFg57
integrity_fg_57
INTEGRITY_FG_57
integrityFg58
integrity_fg_58
INTEGRITY_FG_58
integrityFg59
integrity_fg_59
INTEGRITY_FG_59
integrityFg60
integrity_fg_60
INTEGRITY_FG_60
integrityFg61
integrity_fg_61
INTEGRITY_FG_61
integrityFg62
integrity_fg_62
INTEGRITY_FG_62
integrityFg63
integrity_fg_63
INTEGRITY_FG_63
integrityFg70
integrity_fg_70
INTEGRITY_FG_70
integrityFg80
integrity_fg_80
INTEGRITY_FG_80
col1Ceeb
col1_ceeb
COL1_CEEB
col1Cds
col1_cds
COL1_CDS
col1NotListed
col1_not_listed
COL1_NOT_LISTED
col1Name
col1_name
COL1_NAME
col1City
col1_city
COL1_CITY
col1State
col1_state
COL1_STATE
col1Country
col1_country
COL1_COUNTRY
col1StartDate
col1_start_date
COL1_START_DATE
col1EndDate
col1_end_date
COL1_END_DATE
col1DegreeDate
col1_degree_date
COL1_DEGREE_DATE
col1DegreeObtained
col1_degree_obtained
COL1_DEGREE_OBTAINED
col2Ceeb
col2_ceeb
COL2_CEEB
col2Cds
col2_cds
COL2_CDS
col2NotListed
col2_not_listed
COL2_NOT_LISTED
col2Name
col2_name
COL2_NAME
col2City
col2_city
COL2_CITY
col2State
col2_state
COL2_STATE
col2Country
col2_country
COL2_COUNTRY
col2StartDate
col2_start_date
COL2_START_DATE
col2EndDate
col2_end_date
COL2_END_DATE
col2DegreeDate
col2_degree_date
COL2_DEGREE_DATE
col2DegreeObtained
col2_degree_obtained
COL2_DEGREE_OBTAINED
col3Ceeb
col3_ceeb
COL3_CEEB
col3Cds
col3_cds
COL3_CDS
col3NotListed
col3_not_listed
COL3_NOT_LISTED
col3Name
col3_name
COL3_NAME
col3City
col3_city
COL3_CITY
col3State
col3_state
COL3_STATE
col3Country
col3_country
COL3_COUNTRY
col3StartDate
col3_start_date
COL3_START_DATE
col3EndDate
col3_end_date
COL3_END_DATE
col3DegreeDate
col3_degree_date
COL3_DEGREE_DATE
col3DegreeObtained
col3_degree_obtained
COL3_DEGREE_OBTAINED
col4Ceeb
col4_ceeb
COL4_CEEB
col4Cds
col4_cds
COL4_CDS
col4NotListed
col4_not_listed
COL4_NOT_LISTED
col4Name
col4_name
COL4_NAME
col4City
col4_city
COL4_CITY
col4State
col4_state
COL4_STATE
col4Country
col4_country
COL4_COUNTRY
col4StartDate
col4_start_date
COL4_START_DATE
col4EndDate
col4_end_date
COL4_END_DATE
col4DegreeDate
col4_degree_date
COL4_DEGREE_DATE
col4DegreeObtained
col4_degree_obtained
COL4_DEGREE_OBTAINED
collegeName
college_name
COLLEGE_NAME
districtName
district_name
DISTRICT_NAME
termCode
term_code
TERM_CODE
termDescription
term_description
TERM_DESCRIPTION
majorCode
major_code
MAJOR_CODE
majorDescription
major_description
MAJOR_DESCRIPTION
tstmpSubmit
tstmp_submit
TSTMP_SUBMIT
tstmpCreate
tstmp_create
TSTMP_CREATE
tstmpUpdate
tstmp_update
TSTMP_UPDATE
ssnDisplay
ssn_display
SSN_DISPLAY
fosterYouthStatus
foster_youth_status
FOSTER_YOUTH_STATUS
fosterYouthPreference
foster_youth_preference
FOSTER_YOUTH_PREFERENCE
fosterYouthMis
foster_youth_mis
FOSTER_YOUTH_MIS
fosterYouthPriority
foster_youth_priority
FOSTER_YOUTH_PRIORITY
tstmpDownload
tstmp_download
TSTMP_DOWNLOAD
addressValidation
address_validation
ADDRESS_VALIDATION
zip4
zip4
ZIP4
permAddressValidation
perm_address_validation
PERM_ADDRESS_VALIDATION
permZip4
perm_zip4
PERM_ZIP4
dischargeType
discharge_type
DISCHARGE_TYPE
collegeExpelledSummary
college_expelled_summary
COLLEGE_EXPELLED_SUMMARY
col1ExpelledStatus
col1_expelled_status
COL1_EXPELLED_STATUS
col2ExpelledStatus
col2_expelled_status
COL2_EXPELLED_STATUS
col3ExpelledStatus
col3_expelled_status
COL3_EXPELLED_STATUS
col4ExpelledStatus
col4_expelled_status
COL4_EXPELLED_STATUS
integrityFlags
integrity_flags
INTEGRITY_FLAGS
rdd
rdd
RDD
ssnType
ssn_type
SSN_TYPE
militaryStationedCaEd
military_stationed_ca_ed
MILITARY_STATIONED_CA_ED
integrityFg65
integrity_fg_65
INTEGRITY_FG_65
integrityFg64
integrity_fg_64
INTEGRITY_FG_64
ipAddress
ip_address
IP_ADDRESS
campaign1
campaign1
CAMPAIGN1
campaign2
campaign2
CAMPAIGN2
campaign3
campaign3
CAMPAIGN3
orientation
orientation
ORIENTATION_ENCRYPTED
transgender
transgender
TRANSGENDER_ENCRYPTED
ssnException
ssn_exception
SSN_EXCEPTION
integrityFg71
integrity_fg_71
INTEGRITY_FG_71
preferredFirstname
preferred_firstname
PREFERRED_FIRSTNAME
preferredMiddlename
preferred_middlename
PREFERRED_MIDDLENAME
preferredLastname
preferred_lastname
PREFERRED_LASTNAME
preferredName
preferred_name
PREFERRED_NAME
ssnNo
ssn_no
SSN_NO
completedEleventhGrade
completed_eleventh_grade
COMPLETED_ELEVENTH_GRADE
NO LONGER USED
gradePointAverage
grade_point_average
GRADE_POINT_AVERAGE
highestEnglishCourse
highest_english_course
HIGHEST_ENGLISH_COURSE
highestEnglishGrade
highest_english_grade
HIGHEST_ENGLISH_GRADE
highestMathCourseTaken
highest_math_course_taken
HIGHEST_MATH_COURSE_TAKEN
highestMathTakenGrade
highest_math_taken_grade
HIGHEST_MATH_TAKEN_GRADE
highestMathCoursePassed
highest_math_course_passed
HIGHEST_MATH_COURSE_PASSED
highestMathPassedGrade
highest_math_passed_grade
HIGHEST_MATH_PASSED_GRADE
integrityFg30
integrity_fg_30
INTEGRITY_FG_30
hsCdsFull
hs_cds_full
HS_CDS_FULL
col1CdsFull
col1_cds_full
COL1_CDS_FULL
col2CdsFull
col2_cds_full
COL2_CDS_FULL
col3CdsFull
col3_cds_full
COL3_CDS_FULL
col4CdsFull
col4_cds_full
NOCOL4_CDS_FULL
ssid
ssid
SSID
noPermAddressHomeless
no_perm_address_homeless
NO_PERM_ADDRESS_HOMELESS
noMailingAddressHomeless
no_mailing_address_homeless
NO_MAILING_ADDRESS_HOMELESS
termStart
term_start
TERM_START
termEnd
term_end
TERM_END
homelessYouth
homeless_youth
HOMELESS_YOUTH
integrityFg40
integrity_fg_40
INTEGRITY_FG_40
cipCode
cip_code
CIP_CODE
majorCategory
major_category
MAJOR_CATEGORY
mainphoneintl
mainphoneintl
MAINPHONEINTL
No Longer Used
secondphoneintl
secondphoneintl
SECONDPHONEINTL
No Longer Used
nonCredit
non_credit
NON_CREDIT
integrityFg81
integrity_fg_81
INTEGRITY_FG_81
highestGradeCompleted
highest_grade_completed
HIGHEST_GRADE_COMPLETED
emailVerified
email_verified
EMAIL_VERIFIED
SG v.4.7
emailVerifiedTimestamp
email_verified_timestamp
EMAIL_VERIFIED_TSTMP
SG v.4.7
mainphoneVerified
phone_verified
PHONE_VERIFIED
SG v.4.7
mainphoneVerifiedTimestamp
phone_verified_timestamp
PHONE_VERIFIED_TSTMP
SG v.4.7
preferredMethodOfContact
preferred_contact_method
PREF_CONTACT_METHOD
SG v.4.7
addressValidationOverride
address_validation_override
ADDRESS_VAL_OVERRIDE
SG v.4.7
addressValidationOverrideTimestamp
address_validation_override_timestamp
ADDRESS_VAL_OVER_TSTMP
9 |
appId
app_id
APP_ID
cccId
ccc_id
CCC_ID
status
status
STATUS
collegeId
college_id
COLLEGE_ID
termId
term_id
TERM_ID
NOT USED
majorId
major_id
MAJOR_ID
NOT USED
intendedMajor
intended_major
INTENDED_MAJOR
eduGoal
edu_goal
EDU_GOAL
highestEduLevel
highest_edu_level
HIGHEST_EDU_LEVEL
consentIndicator
consent_indicator
CONSENT_INDICATOR
appLang
app_lang
APP_LANG
ackFinAid
ack_fin_aid
ACK_FIN_AID
finAidRef
fin_aid_ref
FIN_AID_REF
confirmation
confirmation
CONFIRMATION
supPageCode
sup_page_code
SUP_PAGE_CODE
lastPage
last_page
LAST_PAGE
streetaddress1
streetaddress1
STREETADDRESS1
streetaddress2
streetaddress2
STREETADDRESS2
city
city
CITY
postalcode
postalcode
POSTALCODE
state
state
STATE
nonusaprovince
nonusaprovince
NONUSAPROVINCE
country
country
COUNTRY
nonUsAddress
non_us_address
NON_US_ADDRESS
permStreetaddress1
perm_streetaddress1
PERM_STREETADDRESS1
permStreetaddress2
perm_streetaddress2
PERM_STREETADDRESS2
permCity
perm_city
PERM_CITY
permPostalcode
perm_postalcode
PERM_POSTALCODE
permState
perm_state
PERM_STATE
permNonusaprovince
perm_nonusaprovince
PERM_NONUSAPROVINCE
permCountry
perm_country
PERM_COUNTRY
addressSame
address_same
ADDRESS_SAME
mainphone
mainphone
MAINPHONE
mainphoneExt
mainphone_ext
MAINPHONE_EXT
NO LONGER USED
mainphoneAuthText
mainphone_auth_text
MAINPHONE_AUTH_TEXT
NO LONGER USED
secondphone
secondphone
SECONDPHONE
NO LONGER USED
secondphoneExt
secondphone_ext
SECONDPHONE_EXT
NO LONGER USED
secondphoneAuthText
secondphone_auth_text
SECONDPHONE_AUTH_TEXT
NO LONGER USED
enrollStatus
enroll_status
ENROLL_STATUS
hsEduLevel
hs_edu_level
HS_EDU_LEVEL
hsCompDate
hs_comp_date
HS_COMP_DATE
higherEduLevel
higher_edu_level
HIGHER_EDU_LEVEL
higherCompDate
higher_comp_date
HIGHER_COMP_DATE
hsNotAttended
hs_not_attended
HS_NOT_ATTENDED
cahsGraduated
cahs_graduated
CAHS_GRADUATED
cahs3year
cahs_3year
CAHS_3YEAR
hsName
hs_name
HS_NAME
hsCity
hs_city
HS_CITY
hsState
hs_state
HS_STATE
hsCountry
hs_country
HS_COUNTRY
hsCds
hs_cds
HS_CDS
hsCeeb
hs_ceeb
HS_CEEB
hsNotListed
hs_not_listed
HS_NOT_LISTED
homeSchooled
home_schooled
HOME_SCHOOLED
collegeCount
college_count
COLLEGE_COUNT
hsAttendance
hs_attendance
HS_ATTENDANCE
coenrollConfirm
coenroll_confirm
COENROLL_CONFIRM
gender
gender
GENDER
pgFirstname
pg_firstname
PG_FIRSTNAME
pgLastname
pg_lastname
PG_LASTNAME
pgRel
pg_rel
PG_REL
pg1Edu
pg1_edu
PG1_EDU
pg2Edu
pg2_edu
PG2_EDU
pgEduMis
pg_edu_mis
PG_EDU_MIS
under19Ind
under19_ind
UNDER19_IND
dependentStatus
dependent_status
DEPENDENT_STATUS
raceEthnic
race_ethnic
RACE_ETHNIC
hispanic
hispanic
HISPANIC
raceGroup
race_group
RACE_GROUP
raceEthnicFull
race_ethnic_full
RACE_ETHNIC_FULL
ssn
ssn
SSN
birthdate
birthdate
BIRTHDATE
firstname
firstname
FIRSTNAME
middlename
middlename
MIDDLENAME
lastname
lastname
LASTNAME
suffix
suffix
SUFFIX
otherfirstname
otherfirstname
OTHERFIRSTNAME
othermiddlename
othermiddlename
OTHERMIDDLENAME
otherlastname
otherlastname
OTHERLASTNAME
citizenshipStatus
citizenship_status
CITIZENSHIP_STATUS
alienRegNumber
alien_reg_number
ALIEN_REG_NUMBER
visaType
visa_type
VISA_TYPE
noDocuments
no_documents
NO_DOCUMENTS
alienRegIssueDate
alien_reg_issue_date
ALIEN_REG_ISSUE_DATE
alienRegExpireDate
alien_reg_expire_date
ALIEN_REG_EXPIRE_DATE
alienRegNoExpire
alien_reg_no_expire
ALIEN_REG_NO_EXPIRE
militaryStatus
military_status
MILITARY_STATUS
militaryDischargeDate
military_discharge_date
MILITARY_DISCHARGE_DATE
militaryHomeState
military_home_state
MILITARY_HOME_STATE
militaryHomeCountry
military_home_country
MILITARY_HOME_COUNTRY
militaryCaStationed
military_ca_stationed
MILITARY_CA_STATIONED
militaryLegalResidence
military_legal_residence
MILITARY_LEGAL_RESIDENCE
caRes2Years
ca_res_2_years
CA_RES_2_YEARS
caDateCurrent
ca_date_current
CA_DATE_CURRENT
caNotArrived
ca_not_arrived
CA_NOT_ARRIVED
caCollegeEmployee
ca_college_employee
CA_COLLEGE_EMPLOYEE
caSchoolEmployee
ca_school_employee
CA_SCHOOL_EMPLOYEE
caSeasonalAg
ca_seasonal_ag
CA_SEASONAL_AG
caFosterYouth
ca_foster_youth
CA_FOSTER_YOUTH
caOutsideTax
ca_outside_tax
CA_OUTSIDE_TAX
caOutsideTaxYear
ca_outside_tax_year
CA_OUTSIDE_TAX_YEAR
Text | Varchar 50 | SZRAPLY | idmeWorkflowStatus | |||
academicCounseling | academic_counseling | boolean | SZRAPLY | academicCounseling | ||
acceptedTerms | accepted_terms | v SG 4.6 | Boolean | SZRAPLY | acceptedTerms | |
acceptedTermsTimestamp | accepted_terms_timestamp | v SG 4.6 | date timestamp | 255 | SZRAPLY | acceptedTermsTimestamp |
ackFinAid | ack_fin_aid | boolean | SZRAPLY | ackFinAid | ||
addressSame | address_same | boolean | SZRAPLY | addressSame | ||
addressValidation | address_validation | character | 1 | SZRAPLY | addressValidation | |
addressValidationOverride | address_validation_override | boolean | 1 | SZRAPLY | addressValidationOverride | |
addressValidationOverrideTimestamp | address_validation_override_timestamp | date timestamp | 255 | SZRAPLY | addressValidationOverrideTimestamp | |
admIneligible | adm_ineligible | smallint | SZRAPLY | admIneligible | ||
alienRegExpireDate | alien_reg_expire_date | date | SZRAPLY | alienRegExpireDate | ||
alienRegIssueDate | alien_reg_issue_date | date | SZRAPLY | alienRegIssueDate | ||
alienRegNoExpire | alien_reg_no_expire | boolean | SZRAPLY | alienRegNoExpire | ||
alienRegNumber | alien_reg_number | Character varying | 20 | SZRAPLY | alienRegNumber | |
appId | app_id | bigint | SZRAPLY | appId | ||
appLang | app_lang | character | 2 | SZRAPLY | appLang | |
athleticIntercollegiate | athletic_intercollegiate | boolean | SZRAPLY | athleticIntercollegiate | ||
athleticIntramural | athletic_intramural | boolean | SZRAPLY | athleticIntramural | ||
athleticNotInterested | athletic_not_interested | boolean | SZRAPLY | athleticNotInterested | ||
basicSkills | basic_skills | boolean | SZRAPLY | basicSkills | ||
birthdate | birthdate | date | SZRAPLY | birthdate | ||
caCollegeEmployee | ca_college_employee | boolean | SZRAPLY | caCollegeEmployee | ||
caDateCurrent | ca_date_current | date | SZRAPLY | caDateCurrent | ||
caFosterYouth | ca_foster_youth | boolean | SZRAPLY | caFosterYouth | ||
caNotArrived | ca_not_arrived | boolean | SZRAPLY | caNotArrived | ||
caOutsideCollege | ca_outside_college | boolean | SZRAPLY | caOutsideCollege | ||
caOutsideCollegeYear | ca_outside_college_year | date | SZRAPLY | caOutsideCollegeYear | ||
caOutsideLawsuit | ca_outside_lawsuit | boolean | SZRAPLY | caOutsideLawsuit | ||
caOutsideLawsuitYear | ca_outside_lawsuit_year | date | SZRAPLY | caOutsideLawsuitYear | ||
caOutsideTax | ca_outside_tax | boolean | SZRAPLY | caOutsideTax | ||
caOutsideTaxYear | ca_outside_tax_year | date | SZRAPLY | caOutsideTaxYear | ||
caOutsideVoted | ca_outside_voted | boolean | SZRAPLY | caOutsideVoted | ||
caOutsideVotedYear | ca_outside_voted_year | date | SZRAPLY | caOutsideVotedYear | ||
caRes2Years | ca_res_2_years | boolean | SZRAPLY | caRes2Years | ||
caSchoolEmployee | ca_school_employee | boolean | SZRAPLY | caSchoolEmployee | ||
caSeasonalAg | ca_seasonal_ag | boolean | SZRAPLY | caSeasonalAg | ||
cahs3year | cahs_3year | boolean | SZRAPLY | cahs3year | ||
cahsGraduated | cahs_graduated | boolean | SZRAPLY | cahsGraduated | ||
calworks | calworks | boolean | SZRAPLY | calworks | ||
campaign1 | campaign1 | character varying | 255 | SZRAPLY | campaign1 | |
campaign2 | campaign2 | character varying | 255 | SZRAPLY | campaign2 | |
campaign3 | campaign3 | character varying | 255 | SZRAPLY | campaign3 | |
N/A | cap_major_id | NOT USED | bigint | N/A | N/A | |
N/A | cap_term_id | NOT USED | bigint | N/A | N/A | |
careerPlanning | career_planning | boolean | SZRAPLY | careerPlanning | ||
cccId | ccc_id | character varying | 8 | SZRAPLY | cccId | |
N/A | ccgi_token | RESTRICTED | character varying | 256 | N/A | N/A |
childCare | child_care | boolean | SZRAPLY | childCare | ||
cipCode | cip_code | character | 6 | SZRAPLY | cipCode | |
citizenshipStatus | citizenship_status | character | 1 | SZRAPLY | citizenshipStatus | |
city | city | character varying | 50 | SZRAPLY | city | |
coenrollConfirm | coenroll_confirm | boolean | SZRAPLY | coenrollConfirm | ||
col1Cds | col1_cds | character | 6 | SZRAPLY | col1Cds | |
col1CdsFull | col1_cds_full | Character varying | 14 | SZRAPLY | col1CdsFull | |
col1Ceeb | col1_ceeb | character | 7 | SZRAPLY | col1Ceeb | |
col1City | col1_city | character varying | 20 | SZRAPLY | col1City | |
col1Country | col1_country | character | 2 | SZRAPLY | col1Country | |
col1DegreeDate | col1_degree_date | date | SZRAPLY | col1DegreeDate | ||
col1DegreeObtained | col1_degree_obtained | character | 1 | SZRAPLY | col1DegreeObtained | |
col1EndDate | col1_end_date | date | SZRAPLY | col1EndDate | ||
col1ExpelledStatus | col1_expelled_status | boolean | SZRAPLY | col1ExpelledStatus | ||
col1Name | col1_name | character varying | 30 | SZRAPLY | col1Name | |
col1NotListed | col1_not_listed | boolean | SZRAPLY | col1NotListed | ||
col1StartDate | col1_start_date | date | SZRAPLY | col1StartDate | ||
col1State | col1_state | character varying | 30 | SZRAPLY | col1State | |
col2Cds | col2_cds | character | 6 | SZRAPLY | col2Cds | |
col2CdsFull | col2_cds_full | Character varying | 14 | SZRAPLY | col2CdsFull | |
col2Ceeb | col2_ceeb | character | 7 | SZRAPLY | col2Ceeb | |
col2City | col2_city | character varying | 20 | SZRAPLY | col2City | |
col2Country | col2_country | character | 2 | SZRAPLY | col2Country | |
col2DegreeDate | col2_degree_date | date | SZRAPLY | col2DegreeDate | ||
col2DegreeObtained | col2_degree_obtained | character | 1 | SZRAPLY | col2DegreeObtained | |
col2EndDate | col2_end_date | date | SZRAPLY | col2EndDate | ||
col2ExpelledStatus | col2_expelled_status | boolean | SZRAPLY | col2ExpelledStatus | ||
col2Name | col2_name | character varying | 30 | SZRAPLY | col2Name | |
col2NotListed | col2_not_listed | boolean | SZRAPLY | col2NotListed | ||
col2StartDate | col2_start_date | date | SZRAPLY | col2StartDate | ||
col2State | col2_state | character varying | 30 | SZRAPLY | col2State | |
col3Cds | col3_cds | character | 6 | SZRAPLY | col3Cds | |
col3CdsFull | col3_cds_full | Character varying | 14 | SZRAPLY | col3CdsFull | |
col3Ceeb | col3_ceeb | character | 7 | SZRAPLY | col3Ceeb | |
col3City | col3_city | character varying | 20 | SZRAPLY | col3City | |
col3Country | col3_country | character | 2 | SZRAPLY | col3Country | |
col3DegreeDate | col3_degree_date | date | SZRAPLY | col3DegreeDate | ||
col3DegreeObtained | col3_degree_obtained | character | 1 | SZRAPLY | col3DegreeObtained | |
col3EndDate | col3_end_date | date | SZRAPLY | col3EndDate | ||
col3ExpelledStatus | col3_expelled_status | boolean | SZRAPLY | col3ExpelledStatus | ||
col3Name | col3_name | character varying | 30 | SZRAPLY | col3Name | |
col3NotListed | col3_not_listed | boolean | SZRAPLY | col3NotListed | ||
col3StartDate | col3_start_date | date | SZRAPLY | col3StartDate | ||
col3State | col3_state | character varying | 30 | SZRAPLY | col3State | |
col4Cds | col4_cds | character | 6 | SZRAPLY | col4Cds | |
col4CdsFull | col4_cds_full | Character varying | 14 | SZRAPLY | col4CdsFull | |
col4Ceeb | col4_ceeb | character | 7 | SZRAPLY | col4Ceeb | |
col4City | col4_city | character varying | 20 | SZRAPLY | col4City | |
col4Country | col4_country | character | 2 | SZRAPLY | col4Country | |
col4DegreeDate | col4_degree_date | date | SZRAPLY | col4DegreeDate | ||
col4DegreeObtained | col4_degree_obtained | character | 1 | SZRAPLY | col4DegreeObtained | |
col4EndDate | col4_end_date | date | SZRAPLY | col4EndDate | ||
col4ExpelledStatus | col4_expelled_status | boolean | SZRAPLY | col4ExpelledStatus | ||
col4Name | col4_name | character varying | 30 | SZRAPLY | col4Name | |
col4NotListed | col4_not_listed | boolean | SZRAPLY | col4NotListed | ||
col4StartDate | col4_start_date | date | SZRAPLY | col4StartDate | ||
col4State | col4_state | character varying | 30 | SZRAPLY | col4State | |
collegeCount | college_count | smallint | SZRAPLY | collegeCount | ||
collegeExpelledSummary | college_expelled_summary | boolean | SZRAPLY | collegeExpelledSummary | ||
collegeId | college_id | character | 3 | SZRAPLY | collegeId | |
collegeName | college_name | character varying | 50 | SZRAPLY | collegeName | |
comfortableEnglish | comfortable_english | boolean | SZRAPLY | comfortableEnglish | ||
comments | comments | text | 50 | SZRAPLY | comments | |
completedEleventhGrade | completed_eleventh_grade | NO LONGER USED | boolean | SZRAPLY | completedEleventhGrade | |
confirmation | confirmation | character varying | 30 | SZRAPLY | confirmation | |
consentIndicator | consent_indicator | boolean | SZRAPLY | consentIndicator | ||
counselingPersonal | counseling_personal | boolean | SZRAPLY | counselingPersonal | ||
country | country | character | 2 | SZRAPLY | country | |
N/A | cryptokeyid | RESTRICTED USE | integer | N/A | N/A | |
dependentStatus | dependent_status | character | 1 | SZRAPLY | dependentStatus | |
dischargeType | discharge_type | character varying | 1 | SZRAPLY | dischargeType | |
districtName | district_name | character varying | 50 | SZRAPLY | districtName | |
dsps | dsps | boolean | SZRAPLY | dsps | ||
eduGoal | edu_goal | character | 1 | SZRAPLY | eduGoal | |
eligAb540 | elig_ab540 | boolean | SZRAPLY | eligAb540 | ||
character varying | 254 | SZRAPLY | ||||
emailVerified | email_verified | boolean | SZRAPLY | emailVerified | ||
emailVerifiedTimestamp | email_verified_timestamp | timestamp with time zone | 255 | SZRAPLY | emailVerifiedTimestamp | |
employmentAssistance | employment_assistance | boolean | SZRAPLY | employmentAssistance | ||
enrollStatus | enroll_status | character | 1 | SZRAPLY | enrollStatus | |
eops | eops | boolean | SZRAPLY | eops | ||
N/A | esignature | NO LONGER IN USE | boolean | N/A | N/A | |
esl | esl | boolean | SZRAPLY | esl | ||
experience | experience | integer | 1 | SZRAPLY | experience | |
finAidRef | fin_aid_ref | boolean | SZRAPLY | finAidRef | ||
financialAssistance | financial_assistance | boolean | SZRAPLY | financialAssistance | ||
firstname | firstname | character varying | 50 | SZRAPLY | firstname | |
fosterYouthMis | foster_youth_mis | boolean | SZRAPLY | fosterYouthMis | ||
fosterYouthPreference | foster_youth_preference | boolean | SZRAPLY | fosterYouthPreference | ||
fosterYouthPriority | foster_youth_priority | boolean | SZRAPLY | fosterYouthPriority | ||
fosterYouthStatus | foster_youth_status | character | 1 | SZRAPLY | fosterYouthStatus | |
fosterYouths | foster_youths | NO LONGER IN USE | boolean | SZRAPLY | fosterYouths | |
fraudScore | fraud_score | double precision | SZRAPLY | fraudScore | ||
fraudStatus | fraud_status | integer | SZRAPLY | fraudStatus | ||
gender | gender | character | 1 | SZRAPLY | gender | |
gradePointAverage | grade_point_average | Alphanumeric | 5 | SZRAPLY | gradePointAverage | |
healthServices | health_services | boolean | SZRAPLY | healthServices | ||
higherCompDate | higher_comp_date | date | SZRAPLY | higherCompDate | ||
higherEduLevel | higher_edu_level | character | 1 | SZRAPLY | higherEduLevel | |
highestEduLevel | highest_edu_level | character | 5 | SZRAPLY | highestEduLevel | |
highestEnglishCourse | highest_english_course | Integer | SZRAPLY | highestEnglishCourse | ||
highestEnglishGrade | highest_english_grade | Character varying | 2 | SZRAPLY | highestEnglishGrade | |
highestGradeCompleted | highest_grade_completed | varchar | 2 | SZRAPLY | highestGradeCompleted | |
highestMathCoursePassed | highest_math_course_passed | Integer | SZRAPLY | highestMathCoursePassed | ||
highestMathCourseTaken | highest_math_course_taken | Integer | SZRAPLY | highestMathCourseTaken | ||
highestMathPassedGrade | highest_math_passed_grade | Character varying | 2 | SZRAPLY | highestMathPassedGrade | |
highestMathTakenGrade | highest_math_taken_grade | Character varying | 2 | SZRAPLY | highestMathTakenGrade | |
hispanic | hispanic | boolean | SZRAPLY | hispanic | ||
homelessYouth | homeless_youth | boolean | SZRAPLY | homelessYouth | ||
homeSchooled | home_schooled | NOT IN USE | Boolean | SZRAPLY | homeSchooled | |
housingInfo | housing_info | boolean | SZRAPLY | housingInfo | ||
hsAttendance | hs_attendance | smallint | SZRAPLY | hsAttendance | ||
hsCds | hs_cds | character | 6 | SZRAPLY | hsCds | |
hsCdsFull | hs_cds_full | Character varying | 14 | SZRAPLY | hsCdsFull | |
hsCeeb | hs_ceeb | character | 7 | SZRAPLY | hsCeeb | |
hsCity | hs_city | character varying | 20 | SZRAPLY | hsCity | |
hsCompDate | hs_comp_date | date | SZRAPLY | hsCompDate | ||
hsCountry | hs_country | character | 2 | SZRAPLY | hsCountry | |
hsEduLevel | hs_edu_level | character | 1 | SZRAPLY | hsEduLevel | |
hsName | hs_name | character varying | 30 | SZRAPLY | hsName | |
hsNotAttended | hs_not_attended | boolean | SZRAPLY | hsNotAttended | ||
hsNotListed | hs_not_listed | boolean | SZRAPLY | hsNotListed | ||
hsState | hs_state | character | 2 | SZRAPLY | hsState | |
integrityFg01 | integrity_fg_01 | boolean | SZRAPLY | integrityFg01 | ||
integrityFg02 | integrity_fg_02 | boolean | SZRAPLY | integrityFg02 | ||
integrityFg03 | integrity_fg_03 | boolean | SZRAPLY | integrityFg03 | ||
integrityFg04 | integrity_fg_04 | boolean | SZRAPLY | integrityFg04 | ||
integrityFg11 | integrity_fg_11 | boolean | SZRAPLY | integrityFg11 | ||
integrityFg30 | integrity_fg_30 | Boolean | SZRAPLY | integrityFg30 | ||
integrityFg40 | Integrity_fg_40 | boolean | SZRAPLY | integrityFg40 | ||
N/A | Integrity_fg_41 | boolean | N/A | N/A | ||
integrityFg47 | integrity_fg_47 | boolean | SZRAPLY | integrityFg47 | ||
integrityFg48 | integrity_fg_48 | boolean | SZRAPLY | integrityFg48 | ||
integrityFg49 | integrity_fg_49 | boolean | SZRAPLY | integrityFg49 | ||
integrityFg50 | integrity_fg_50 | boolean | SZRAPLY | integrityFg50 | ||
integrityFg51 | integrity_fg_51 | boolean | SZRAPLY | integrityFg51 | ||
integrityFg52 | integrity_fg_52 | boolean | SZRAPLY | integrityFg52 | ||
integrityFg53 | integrity_fg_53 | boolean | SZRAPLY | integrityFg53 | ||
integrityFg54 | integrity_fg_54 | boolean | SZRAPLY | integrityFg54 | ||
integrityFg55 | integrity_fg_55 | boolean | SZRAPLY | integrityFg55 | ||
integrityFg56 | integrity_fg_56 | boolean | SZRAPLY | integrityFg56 | ||
integrityFg57 | integrity_fg_57 | boolean | SZRAPLY | integrityFg57 | ||
integrityFg58 | integrity_fg_58 | boolean | SZRAPLY | integrityFg58 | ||
integrityFg59 | integrity_fg_59 | boolean | SZRAPLY | integrityFg59 | ||
integrityFg60 | integrity_fg_60 | boolean | SZRAPLY | integrityFg60 | ||
integrityFg61 | integrity_fg_61 | boolean | SZRAPLY | integrityFg61 | ||
integrityFg62 | integrity_fg_62 | boolean | SZRAPLY | integrityFg62 | ||
integrityFg63 | integrity_fg_63 | boolean | SZRAPLY | integrityFg63 | ||
integrityFg64 | integrity_fg_64 | boolean | SZRAPLY | integrityFg64 | ||
integrityFg65 | integrity_fg_65 | boolean | SZRAPLY | integrityFg65 | ||
integrityFg70 | integrity_fg_70 | boolean | SZRAPLY | integrityFg70 | ||
integrityFg71 | integrity_fg_71 | boolean | SZRAPLY | integrityFg71 | ||
integrityFg80 | integrity_fg_80 | boolean | SZRAPLY | integrityFg80 | ||
integrityFg81 | Integrity_fg_81 | boolean | SZRAPLY | integrityFg81 | ||
integrityFlags | integrity_flags | character varying | 255 | SZRAPLY | integrityFlags | |
intendedMajor | intended_major | character varying | 30 | SZRAPLY | intendedMajor | |
ipAddress | ip_address | character varying | 15 | SZRAPLY | ipAddress | |
ipAddressAtAccountCreation | ip_address_at_account_creation | v SG 4.6 | character varying | 40 | SZRAPLY | ipAddressAtAccountCreation |
ipAddressAtAppCreation | ip_address_at_app_creation | v SG 4.6 | character varying | 40 | SZRAPLY | ipAddressAtAppCreation |
lastname | lastname | character varying | 50 | SZRAPLY | lastname | |
lastPage | last_page | character varying | 25 | SZRAPLY | lastPage | |
mailingAddressValidationOverride | mailing_address_validation_override | v SG 4.6 | boolean | SZRAPLY | mailingAddressValidationOverride | |
mainphone | mainphone | character varying | 19 | SZRAPLY | mainphone | |
mainphoneAuthText | mainphone_auth_text | NO LONGER IN USE | boolean | SZRAPLY | mainphoneAuthText | |
mainphoneExt | mainphone_ext | NO LONGER IN USE | character varying | 4 | SZRAPLY | mainphoneExt |
mainphoneintl | mainphoneintl | NO LONGER IN USE | character varying | 25 | SZRAPLY | mainphoneintl |
majorCategory | major_category | character varying | 100 | SZRAPLY | majorCategory | |
majorCode | major_code | character varying | 30 | SZRAPLY | majorCode | |
majorDescription | major_description | character varying | 100 | SZRAPLY | majorDescription | |
majorId | major_id | SYSTEM USE ONLY | bigint | SZRAPLY | majorId | |
middlename | middlename | character varying | 50 | SZRAPLY | middlename | |
militaryCaStationed | military_ca_stationed | boolean | SZRAPLY | militaryCaStationed | ||
militaryDischargeDate | military_discharge_date | date | SZRAPLY | militaryDischargeDate | ||
militaryHomeCountry | military_home_country | character | 2 | SZRAPLY | militaryHomeCountry | |
militaryHomeState | military_home_state | character | 2 | SZRAPLY | militaryHomeState | |
militaryLegalResidence | military_legal_residence | character | 2 | SZRAPLY | militaryLegalResidence | |
militaryStationedCaEd | military_stationed_ca_ed | boolean | SZRAPLY | militaryStationedCaEd | ||
militaryStatus | military_status | character | 1 | SZRAPLY | militaryStatus | |
N/A | military_veteran_consent | RESTRICTED USE | boolean | N/A | N/A | |
noDocuments | no_documents | boolean | SZRAPLY | noDocuments | ||
noMailingAddressHomeless | no_mailing_address_homeless | boolean | SZRAPLY | noMailingAddressHomeless | ||
noPermAddressHomeless | no_perm_address_homeless | boolean | SZRAPLY | noPermAddressHomeless | ||
nonCredit | non_credit | boolean | SZRAPLY | nonCredit | ||
nonUsAddress | non_us_address | boolean | SZRAPLY | nonUsAddress | ||
nonusaprovince | nonusaprovince | character varying | 30 | SZRAPLY | nonusaprovince | |
onlineClasses | online_classes | boolean | SZRAPLY | onlineClasses | ||
orientation | orientation | RESTRICTED USE | byte | 1 | SZRAPLY | orientation |
N/A | orientation_encrypted | RESTRICTED USE | text | N/A | N/A | |
otherfirstname | otherfirstname | character varying | 50 | SZRAPLY | otherfirstname | |
otherlastname | otherlastname | character varying | 50 | SZRAPLY | otherlastname | |
othermiddlename | othermiddlename | character varying | 50 | SZRAPLY | othermiddlename | |
permAddressValidation | perm_address_validation | character | 1 | SZRAPLY | permAddressValidation | |
permCity | perm_city | character varying | 50 | SZRAPLY | permCity | |
permCountry | perm_country | character | 2 | SZRAPLY | permCountry | |
permNonusaprovince | perm_nonusaprovince | character varying | 30 | SZRAPLY | permNonusaprovince | |
permPostalcode | perm_postalcode | character varying | 20 | SZRAPLY | permPostalcode | |
permState | perm_state | character | 2 | SZRAPLY | permState | |
permStreetaddress1 | perm_streetaddress1 | character varying | 50 | SZRAPLY | permStreetaddress1 | |
permStreetaddress2 | perm_streetaddress2 | character varying | 50 | SZRAPLY | permStreetaddress2 | |
permZip4 | perm_zip4 | character | 4 | SZRAPLY | permZip4 | |
pgEduMis | pg_edu_mis | character | 2 | SZRAPLY | pgEduMis | |
pgFirstname | pg_firstname | character varying | 20 | SZRAPLY | pgFirstname | |
pgLastname | pg_lastname | character varying | 25 | SZRAPLY | pgLastname | |
pgRel | pg_rel | character | 1 | SZRAPLY | pgRel | |
pg1Edu | pg1_edu | character | 1 | SZRAPLY | pg1Edu | |
pg2Edu | pg2_edu | character | 1 | SZRAPLY | pg2Edu | |
phoneType | phone_type | v SG 4.6 | varchar | 10 | SZRAPLY | phoneType |
phoneVerified | phone_verified | Boolean | SZRAPLY | phoneVerified | ||
phoneVerifiedTimestamp | phone_verified_timestamp | timestamp with time zone | SZRAPLY | phoneVerifiedTimestamp | ||
postalcode | postalcode | character varying | 20 | SZRAPLY | postalcode | |
preferredMethodOfContact | preferred_contact_method | VarChar | 10 | SZRAPLY | preferredMethodOfContact | |
preferredFirstname | preferred_firstname | Text string | 50 | SZRAPLY | preferredFirstname | |
preferredLastname | preferred_lastname | NO LONGER IN USE | character varying | 50 | SZRAPLY | preferredLastname |
preferredMiddlename | preferred_middlename | NO LONGER IN USE | character varying | 50 | SZRAPLY | preferredMiddlename |
preferredName | preferred_name | NO LONGER IN USE | boolean | 1 | SZRAPLY | preferredName |
raceEthnic | race_ethnic | text | SZRAPLY | raceEthnic | ||
raceEthnicFull | race_ethnic_full | text | 805 | SZRAPLY | raceEthnicFull | |
raceGroup | race_group | text | SZRAPLY | raceGroup | ||
rdd | rdd | date | SZRAPLY | rdd | ||
recommend | recommend | integer | 1 | SZRAPLY | recommend | |
reentryProgram | reentry_program | boolean | SZRAPLY | reentryProgram | ||
resAreaA | res_area_a | smallint | SZRAPLY | resAreaA | ||
resAreaB | res_area_b | smallint | SZRAPLY | resAreaB | ||
resAreaC | res_area_c | smallint | SZRAPLY | resAreaC | ||
resAreaD | res_area_d | smallint | SZRAPLY | resAreaD | ||
resPrevDate | res_prev_date | date | SZRAPLY | resPrevDate | ||
resStatus | res_status | character | 1 | SZRAPLY | resStatus | |
resStatusChange | res_status_change | boolean | SZRAPLY | resStatusChange | ||
N/A | salt | SYSTEM USE ONLY | text | N/A | N/A | |
scholarshipInfo | scholarship_info | boolean | SZRAPLY | scholarshipInfo | ||
secondphoneAuthText | secondphone_auth_text | NO LONGER IN USE | boolean | SZRAPLY | secondphoneAuthText | |
secondphoneExt | secondphone_ext | NO LONGER IN USE | character varying | 4 | SZRAPLY | secondphoneExt |
secondphone | secondphone | NO LONGER IN USE | character varying | 14 | SZRAPLY | secondphone |
secondphoneintl | secondphoneintl | NO LONGER IN USE | character varying | 25 | SZRAPLY | secondphoneintl |
signature | text | SZRAPLY | N/A | |||
sisReceipt | sis_receipt | boolean | SZRAPLY | sisReceipt | ||
ssid | ssid | character varying | 10 | SZRAPLY | ssid | |
ssn | ssn | RESTRICTED USE | text | 11 | SZRAPLY | ssn |
ssnDisplay | ssn_display | character varying | 11 | SZRAPLY | ssnDisplay | |
ssnException | ssn_exception | boolean | SZRAPLY | ssnException | ||
ssnNo | ssn_no | character | SZRAPLY | ssnNo | ||
ssnType | ssn_type | character | 1 | SZRAPLY | ssnType | |
state | state | character | 2 | SZRAPLY | state | |
status | status | character | 1 | SZRAPLY | status | |
streetaddress1 | streetaddress1 | character varying | 50 | SZRAPLY | streetaddress1 | |
streetaddress2 | streetaddress2 | character varying | 50 | SZRAPLY | streetaddress2 | |
studentGovernment | student_government | boolean | SZRAPLY | studentGovernment | ||
studentParent | student_parent | SG 4.7 | boolean | SZRAPLY | studentParent | |
suffix | suffix | character varying | 3 | SZRAPLY | suffix | |
supPageCode | sup_page_code | NO LONGER IN USE | character varying | 30 | SZRAPLY | supPageCode |
tanfSsiGa | tanf_ssi_ga | boolean | SZRAPLY | tanfSsiGa | ||
termCode | term_code | character varying | 15 | SZRAPLY | termCode | |
termDescription | term_description | character varying | 100 | SZRAPLY | termDescription | |
termId | term_id | SYSTEM USE ONLY | bigint | SZRAPLY | termId | |
termEnd | term_end | date | 13 | SZRAPLY | termEnd | |
termStart | term_start | date | 13 | SZRAPLY | termStart | |
testingAssessment | testing_assessment | boolean | SZRAPLY | testingAssessment | ||
transferInfo | transfer_info | boolean | SZRAPLY | transferInfo | ||
transgender | transgender | RESTRICTED USE | Byte | 1 | SZRAPLY | transgender |
N/A | transgender_encrypted | RESTRICTED USE | N/A | N/A | ||
tstmpCreate | tstmp_create | timestamp with time zone | SZRAPLY | tstmpCreate | ||
tstmpDownload | tstmp_download | timestamp with time zone | SZRAPLY | tstmpDownload | ||
tstmpSubmit | tstmp_submit | timestamp with time zone | SZRAPLY | tstmpSubmit | ||
tstmpUpdate | tstmp_update | timestamp with time zone | SZRAPLY | tstmpUpdate | ||
tutoringServices | tutoring_services | boolean | SZRAPLY | tutoringServices | ||
under19Ind | under19_ind | boolean | SZRAPLY | under19Ind | ||
veteransServices | veterans_services | boolean | SZRAPLY | veteransServices | ||
visaType | visa_type | alphanumeric | 2 | SZRAPLY | visaType | |
zip4 | zip4 | character | 4 | SZRAPLY | zip4 |
Supplemental Questions Data Fields Mappings - MSQL
The table below pertains to the Supplemental Questions fields for the CCCApply Standard/Noncredit Application. For more information, see the Working With Supplemental Questions User Guide.
College Adaptor Payload Name | CCC Field Name | DB Staging Table |
---|
College Adaptor Payload Name | Notes |
---|---|
appId | app_id |
SZRAPLY | appId | |
suppText01 | supp_text_01 |
SZRAPLY | suppText01 | ||
suppText02 | supp_text_02 |
SZRAPLY | suppText02 | |
suppText03 | supp_text_03 |
SZRAPLY | suppText03 | |
suppText04 | supp_text_04 |
SZRAPLY | suppText04 | |
suppText05 | supp_text |
_05 | SZRAPLY | suppText05 | |
suppText06 | supp_text_06 |
SZRAPLY | suppText06 | |
suppText07 | supp_text_07 |
SZRAPLY | suppText07 | |
suppText08 | supp_text_08 |
SZRAPLY | suppText08 | |
suppText09 | supp_text_09 |
SZRAPLY | suppText09 | |
suppText10 | supp_text_10 |
SZRAPLY | suppText10 | ||
suppText11 | supp_text_11 |
SZRAPLY | suppText11 | ||
suppText12 | supp_text_12 |
SZRAPLY | suppText12 | |
suppText13 | supp_text_13 |
SZRAPLY | suppText13 | |
suppText14 | supp_text_14 |
SZRAPLY | suppText14 | |
suppText15 | supp_text |
_15 | SZRAPLY | suppText15 | |
suppText16 | supp_text_16 |
SZRAPLY | suppText16 | |
suppText17 | supp_text_17 |
SZRAPLY | suppText17 | |
suppText18 | supp_text_18 |
SZRAPLY | suppText18 | |
suppText19 | supp_text_19 |
SZRAPLY | suppText19 | |
suppText20 | supp_text_20 |
SZRAPLY | suppText20 | ||
suppCheck01 | supp_check_01 |
SZRAPLY | suppCheck01 | ||
suppCheck02 | supp_check_02 |
SZRAPLY | suppCheck02 | |
suppCheck03 | supp_check_03 |
SZRAPLY | suppCheck03 | |
suppCheck04 | supp_check_04 |
SZRAPLY | suppCheck04 | |
suppCheck05 | supp_check |
_05 | SZRAPLY | suppCheck05 | |
suppCheck06 | supp_check_06 |
SZRAPLY | suppCheck06 | |
suppCheck07 | supp_check_07 |
SZRAPLY | suppCheck07 | |
suppCheck08 | supp_check_08 |
SZRAPLY | suppCheck08 | |
suppCheck09 | supp_check_09 |
SZRAPLY | suppCheck09 | |
suppCheck10 | supp_check_10 |
SZRAPLY | suppCheck10 | ||
suppCheck11 | supp_check_11 |
SZRAPLY | suppCheck11 | ||
suppCheck12 | supp_check_12 |
SZRAPLY | suppCheck12 | |
suppCheck13 | supp_check_13 |
SZRAPLY | suppCheck13 | |
suppCheck14 | supp_check_14 |
SZRAPLY | suppCheck14 | |
suppCheck15 | supp_check |
_15 | SZRAPLY | suppCheck15 | |
suppCheck16 | supp_check_16 |
SZRAPLY | suppCheck16 | |
suppCheck17 | supp_check_17 |
SZRAPLY | suppCheck17 | |
suppCheck18 | supp_check_18 |
SZRAPLY | suppCheck18 | |
suppCheck19 | supp_check_19 |
SZRAPLY | suppCheck19 | |
suppCheck20 | supp_check_20 |
SZRAPLY | suppCheck20 | ||
suppCheck21 | supp_check_21 |
SZRAPLY | suppCheck21 | ||
suppCheck22 | supp_check_22 |
SZRAPLY | suppCheck22 | |
suppCheck23 | supp_check_23 |
SZRAPLY | suppCheck23 | |
suppCheck24 | supp_check_24 |
SZRAPLY | suppCheck24 | |
suppCheck25 | supp_check |
_25 | SZRAPLY | suppCheck25 | |
suppCheck26 | supp_check_26 |
SZRAPLY | suppCheck26 | |
suppCheck27 | supp_check_27 |
SZRAPLY | suppCheck27 | |
suppCheck28 | supp_check_28 |
SZRAPLY | suppCheck28 | |
suppCheck29 | supp_check_29 |
SZRAPLY | suppCheck29 | |
suppCheck30 | supp_check_30 |
SZRAPLY | suppCheck30 | ||
suppCheck31 | supp_check_31 |
SZRAPLY | suppCheck31 | ||
suppCheck32 | supp_check_32 |
SZRAPLY | suppCheck32 | |
suppCheck33 | supp_check_33 |
SZRAPLY | suppCheck33 | |
suppCheck34 | supp_check_34 |
SZRAPLY | suppCheck34 | |
suppCheck35 | supp_check |
_35 | SZRAPLY | suppCheck35 | |
suppCheck36 | supp_check_36 |
SZRAPLY | suppCheck36 | |
suppCheck37 | supp_check_37 |
SZRAPLY | suppCheck37 | |
suppCheck38 | supp_check_38 |
SZRAPLY | suppCheck38 | |
suppCheck39 | supp_check_39 |
SZRAPLY | suppCheck39 | |
suppCheck40 | supp_check_40 |
SZRAPLY | suppCheck40 | ||
suppCheck41 | supp_check_41 |
SZRAPLY | suppCheck41 | ||
suppCheck42 | supp_check_42 |
SZRAPLY | suppCheck42 | |
suppCheck43 | supp_check_43 |
SZRAPLY | suppCheck43 | |
suppCheck44 | supp_check_44 |
SZRAPLY | suppCheck44 | |
suppCheck45 | supp_check |
_45 | SZRAPLY | suppCheck45 | |
suppCheck46 | supp_check_46 |
SZRAPLY | suppCheck46 | |
suppCheck47 | supp_check_47 |
SZRAPLY | suppCheck47 | |
suppCheck48 | supp_check_48 |
SZRAPLY | suppCheck48 | |
suppCheck49 | supp_check_49 |
SZRAPLY | suppCheck49 | |
suppCheck50 | supp_check_50 |
SZRAPLY | suppCheck50 | ||
suppYesno01 | supp_yesno_01 |
SZRAPLY | suppYesno01 | ||
suppYesno02 | supp_yesno_02 |
SZRAPLY | suppYesno02 | |
suppYesno03 | supp_yesno_03 |
SZRAPLY | suppYesno03 | |
suppYesno04 | supp_yesno_04 |
SZRAPLY | suppYesno04 | |
suppYesno05 | supp_yesno |
_05 | SZRAPLY | suppYesno05 | |
suppYesno06 | supp_yesno_06 |
SZRAPLY | suppYesno06 | |
suppYesno07 | supp_yesno_07 |
SZRAPLY | suppYesno07 | |
suppYesno08 | supp_yesno_08 |
SZRAPLY | suppYesno08 | |
suppYesno09 | supp_yesno_09 |
SZRAPLY | suppYesno09 | |
suppYesno10 | supp_yesno_10 |
SZRAPLY | suppYesno10 | ||
suppYesno11 | supp_yesno_11 |
SZRAPLY | suppYesno11 | ||
suppYesno12 | supp_yesno_12 |
SZRAPLY | suppYesno12 | |
suppYesno13 | supp_yesno_13 |
SZRAPLY | suppYesno13 | |
suppYesno14 | supp_yesno_14 |
SZRAPLY | suppYesno14 | |
suppYesno15 | supp_yesno |
_15 | SZRAPLY | suppYesno15 | |
suppYesno16 | supp_yesno_16 |
SZRAPLY | suppYesno16 | |
suppYesno17 | supp_yesno_17 |
SZRAPLY | suppYesno17 | |
suppYesno18 | supp_yesno_18 |
SZRAPLY | suppYesno18 | |
suppYesno19 | supp_yesno_19 |
SZRAPLY | suppYesno19 | |
suppYesno20 | supp_yesno_20 |
SZRAPLY | suppYesno20 | ||
suppYesno21 | supp_yesno_21 |
SZRAPLY | suppYesno21 | ||
suppYesno22 | supp_yesno_22 |
SZRAPLY | suppYesno22 | |
suppYesno23 | supp_yesno_23 |
SZRAPLY | suppYesno23 | |
suppYesno24 | supp_yesno_24 |
SZRAPLY | suppYesno24 | |
suppYesno25 | supp_yesno |
_25 | SZRAPLY | suppYesno25 | |
suppYesno26 | supp_yesno_26 |
SZRAPLY | suppYesno26 | |
suppYesno27 | supp_yesno_27 |
SZRAPLY | suppYesno27 | |
suppYesno28 | supp_yesno_28 |
SZRAPLY | suppYesno28 | |
suppYesno29 | supp_yesno_29 |
SZRAPLY | suppYesno29 | |
suppYesno30 | supp_yesno_30 |
SZRAPLY | suppYesno30 | ||
suppMenu01 | supp_menu_01 |
SZRAPLY | suppMenu01 | ||
suppMenu02 | supp_menu_02 |
SZRAPLY | suppMenu02 | |
suppMenu03 | supp_menu_03 |
SZRAPLY | suppMenu03 | |
suppMenu04 | supp_menu_04 |
SZRAPLY | suppMenu04 | |
suppMenu05 | supp_menu |
_05 | SZRAPLY | suppMenu05 | |
suppMenu06 | supp_menu_06 |
SZRAPLY | suppMenu06 | |
suppMenu07 | supp_menu_07 |
SZRAPLY | suppMenu07 | |
suppMenu08 | supp_menu_08 |
SZRAPLY | suppMenu08 | |
suppMenu09 | supp_menu_09 |
SZRAPLY | suppMenu09 | |
suppMenu10 | supp_menu_10 |
SZRAPLY | suppMenu10 | ||
suppMenu11 | supp_menu_11 |
SZRAPLY | suppMenu11 | ||
suppMenu12 | supp_menu_12 |
SZRAPLY | suppMenu12 | |
suppMenu13 | supp_menu_13 |
SZRAPLY | suppMenu13 | |
suppMenu14 | supp_menu_14 |
SZRAPLY | suppMenu14 | |
suppMenu15 | supp_menu |
_15 | SZRAPLY | suppMenu15 | |
suppMenu16 | supp_menu_16 |
SZRAPLY | suppMenu16 | |
suppMenu17 | supp_menu_17 |
SZRAPLY | suppMenu17 | |
suppMenu18 | supp_menu_18 |
SZRAPLY | suppMenu18 | |
suppMenu19 | supp_menu_19 |
SZRAPLY | suppMenu19 | |
suppMenu20 | supp_menu_20 |
SZRAPLY | suppMenu20 | ||
suppMenu21 | supp_menu_21 |
SZRAPLY | suppMenu21 | ||
suppMenu22 | supp_menu_22 |
SZRAPLY | suppMenu22 | |
suppMenu23 | supp_menu_23 |
SZRAPLY | suppMenu23 | |
suppMenu24 | supp_menu_24 |
SZRAPLY | suppMenu24 | |
suppMenu25 | supp_menu |
_25 | SZRAPLY | suppMenu25 | |
suppMenu26 | supp_menu_26 |
SZRAPLY | suppMenu26 | |
suppMenu27 | supp_menu_27 |
SZRAPLY | suppMenu27 | |
suppMenu28 | supp_menu_28 |
SZRAPLY | suppMenu28 | |
suppMenu29 | supp_menu_29 |
SZRAPLY | suppMenu29 | |
suppMenu30 | supp_menu_30 |
SZRAPLY | suppMenu30 | ||
suppDate01 | supp_date_01 |
SZRAPLY | suppDate01 | ||
suppDate02 | supp_date_02 |
SZRAPLY | suppDate02 | |
suppDate03 | supp_date_03 |
SZRAPLY | suppDate03 | |
suppDate04 | supp_date_04 |
SZRAPLY | suppDate04 | |
suppDate05 | supp_date |
_05 | SZRAPLY | suppDate05 | |
suppState01 | supp_state_01 |
SZRAPLY | suppState01 | |
suppState02 | supp_state_02 |
SZRAPLY | suppState02 | |
suppState03 | supp_state_03 |
SZRAPLY | suppState03 | |
suppState04 | supp_state_04 |
SZRAPLY | suppState04 | |
suppState05 | supp_state_05 |
SZRAPLY | suppState05 | ||
suppCountry01 | supp_country_01 |
SZRAPLY | suppCountry01 | ||
suppCountry02 | supp_country_02 |
SZRAPLY | suppCountry02 | |
suppCountry03 | supp_country_03 |
SZRAPLY | suppCountry03 | |
suppCountry04 | supp_country_04 |
SZRAPLY | suppCountry04 | |
suppCountry05 | supp_country_05 |
SZRAPLY | suppCountry05 | ||
suppPhonenumber01 | supp_phonenumber_01 |
SZRAPLY | suppPhonenumber01 | ||
suppPhonenumber02 | supp_phonenumber_02 |
SZRAPLY | suppPhonenumber02 | |
suppPhonenumber03 | supp_phonenumber_03 |
SZRAPLY | suppPhonenumber03 | |
suppPhonenumber04 | supp_phonenumber_04 |
SZRAPLY | suppPhonenumber04 | ||
suppPhonenumber05 | supp_phonenumber_05 |
SZRAPLY | suppPhonenumber05 | ||
suppSecret01 | supp_secret_01 |
SZRAPLY | suppSecret01 | ||
suppSecret02 | supp_secret_02 |
SZRAPLY | suppSecret02 | |
suppSecret03 | supp_secret_03 |
SZRAPLY | suppSecret03 | |
suppSecret04 | supp_secret_04 |
SZRAPLY | suppSecret04 | ||
suppSecret05 | supp_secret_05 |
SZRAPLY | suppSecret05 |