Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
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 Data Element | Apply: College Adaptor |
CCC Field Name
DB Staging Table
Notes
studentParent
student_parent
SG v.4.7
Element | System | Type | Length | MS SQL TABLE | MS SQL FIELD NAME | |
academic_counseling | academicCounseling | boolean | SZRAPLY | academicCounseling | ||
accepted_terms | acceptedTerms | v SG |
4.6 | Boolean |
SZRAPLY | acceptedTerms | |
accepted_terms_timestamp | acceptedTermsTimestamp | v SG |
4.6 |
ipAddressAtAccountCreation
ip_address_at_account_creation
SG v.4.7
ipAddressAtAppCreation
ip_address_at_app_creation
SG v.4.7
mailingAddressValidationOverride
mailing_address_validation_override
SG v.4.7
phoneType
phone_type
SG v.4.7
appId
app_id
cccId
ccc_id
status
status
collegeId
college_id
termId
term_id
NOT USED
majorId
major_id
NOT USED
intendedMajor
intended_major
eduGoal
edu_goal
highestEduLevel
highest_edu_level
consentIndicator
consent_indicator
appLang
app_lang
ackFinAid
ack_fin_aid
finAidRef
fin_aid_ref
confirmation
confirmation
supPageCode
sup_page_code
lastPage
last_page
streetaddress1
streetaddress1
streetaddress2
streetaddress2
city
city
postalcode
postalcode
state
state
nonusaprovince
nonusaprovince
country
country
nonUsAddress
non_us_address
permStreetaddress1
perm_streetaddress1
permStreetaddress2
perm_streetaddress2
permCity
perm_city
permPostalcode
perm_postalcode
permState
perm_state
permNonusaprovince
perm_nonusaprovince
permCountry
perm_country
addressSame
address_same
mainphone
mainphone
mainphoneExt
mainphone_ext
NO LONGER USED
mainphoneAuthText
mainphone_auth_text
NO LONGER USED
secondphone
secondphone
NO LONGER USED
secondphoneExt
secondphone_ext
NO LONGER USED
secondphoneAuthText
secondphone_auth_text
NO LONGER USED
enrollStatus
enroll_status
hsEduLevel
hs_edu_level
hsCompDate
hs_comp_date
higherEduLevel
higher_edu_level
higherCompDate
higher_comp_date
hsNotAttended
hs_not_attended
cahsGraduated
cahs_graduated
cahs3year
cahs_3year
hsName
hs_name
hsCity
hs_city
hsState
hs_state
hsCountry
hs_country
hsCds
hs_cds
hsCeeb
hs_ceeb
hsNotListed
hs_not_listed
homeSchooled
home_schooled
collegeCount
college_count
hsAttendance
hs_attendance
coenrollConfirm
coenroll_confirm
gender
gender
pgFirstname
pg_firstname
pgLastname
pg_lastname
pgRel
pg_rel
pg1Edu
pg1_edu
pg2Edu
pg2_edu
pgEduMis
pg_edu_mis
under19Ind
under19_ind
dependentStatus
dependent_status
raceEthnic
race_ethnic
hispanic
hispanic
raceGroup
race_group
raceEthnicFull
race_ethnic_full
ssn
ssn
birthdate
birthdate
firstname
firstname
middlename
middlename
lastname
lastname
suffix
suffix
otherfirstname
otherfirstname
othermiddlename
othermiddlename
otherlastname
otherlastname
citizenshipStatus
citizenship_status
alienRegNumber
alien_reg_number
visaType
visa_type
noDocuments
no_documents
alienRegIssueDate
alien_reg_issue_date
alienRegExpireDate
alien_reg_expire_date
alienRegNoExpire
alien_reg_no_expire
militaryStatus
military_status
militaryDischargeDate
military_discharge_date
militaryHomeState
military_home_state
militaryHomeCountry
military_home_country
militaryCaStationed
military_ca_stationed
militaryLegalResidence
military_legal_residence
caRes2Years
ca_res_2_years
caDateCurrent
ca_date_current
caNotArrived
ca_not_arrived
caCollegeEmployee
ca_college_employee
caSchoolEmployee
ca_school_employee
caSeasonalAg
ca_seasonal_ag
caFosterYouth
ca_foster_youth
caOutsideTax
ca_outside_tax
caOutsideTaxYear
ca_outside_tax_year
caOutsideVoted
ca_outside_voted
caOutsideVotedYear
ca_outside_voted_year
caOutsideCollege
ca_outside_college
caOutsideCollegeYear
ca_outside_college_year
caOutsideLawsuit
ca_outside_lawsuit
caOutsideLawsuitYear
ca_outside_lawsuit_year
resStatus
res_status
resStatusChange
res_status_change
resPrevDate
res_prev_date
admIneligible
adm_ineligible
eligAb540
elig_ab540
resAreaA
res_area_a
resAreaB
res_area_b
resAreaC
res_area_c
resAreaD
res_area_d
experience
experience
recommend
recommend
comments
comments
comfortableEnglish
comfortable_english
financialAssistance
financial_assistance
tanfSsiGa
tanf_ssi_ga
fosterYouths
foster_youths
athleticIntercollegiate
athletic_intercollegiate
athleticIntramural
athletic_intramural
athleticNotInterested
athletic_not_interested
academicCounseling
academic_counseling
basicSkills
basic_skills
calworks
calworks
careerPlanning
career_planning
childCare
child_care
counselingPersonal
counseling_personal
dsps
dsps
eops
eops
esl
esl
healthServices
health_services
housingInfo
housing_info
employmentAssistance
employment_assistance
onlineClasses
online_classes
reentryProgram
reentry_program
scholarshipInfo
scholarship_info
studentGovernment
student_government
testingAssessment
testing_assessment
transferInfo
transfer_info
tutoringServices
tutoring_services
veteransServices
veterans_services
integrityFg01
integrity_fg_01
integrityFg02
integrity_fg_02
integrityFg03
integrity_fg_03
integrityFg04
integrity_fg_04
integrityFg11
integrity_fg_11
integrityFg47
integrity_fg_47
integrityFg48
integrity_fg_48
integrityFg49
integrity_fg_49
integrityFg50
integrity_fg_50
integrityFg51
integrity_fg_51
integrityFg52
integrity_fg_52
integrityFg53
integrity_fg_53
integrityFg54
integrity_fg_54
integrityFg55
integrity_fg_55
integrityFg56
integrity_fg_56
integrityFg57
integrity_fg_57
integrityFg58
integrity_fg_58
integrityFg59
integrity_fg_59
integrityFg60
integrity_fg_60
integrityFg61
integrity_fg_61
integrityFg62
integrity_fg_62
integrityFg63
integrity_fg_63
integrityFg70
integrity_fg_70
integrityFg80
integrity_fg_80
col1Ceeb
col1_ceeb
col1Cds
col1_cds
col1NotListed
col1_not_listed
col1Name
col1_name
col1City
col1_city
col1State
col1_state
col1Country
col1_country
col1StartDate
col1_start_date
col1EndDate
col1_end_date
col1DegreeDate
col1_degree_date
col1DegreeObtained
col1_degree_obtained
col2Ceeb
col2_ceeb
col2Cds
col2_cds
col2NotListed
col2_not_listed
col2Name
col2_name
col2City
col2_city
col2State
col2_state
col2Country
col2_country
col2StartDate
col2_start_date
col2EndDate
col2_end_date
col2DegreeDate
col2_degree_date
col2DegreeObtained
col2_degree_obtained
col3Ceeb
col3_ceeb
col3Cds
col3_cds
col3NotListed
col3_not_listed
col3Name
col3_name
col3City
col3_city
col3State
col3_state
col3Country
col3_country
col3StartDate
col3_start_date
col3EndDate
col3_end_date
col3DegreeDate
col3_degree_date
col3DegreeObtained
col3_degree_obtained
col4Ceeb
col4_ceeb
col4Cds
col4_cds
col4NotListed
col4_not_listed
col4Name
col4_name
col4City
col4_city
col4State
col4_state
col4Country
col4_country
col4StartDate
col4_start_date
col4EndDate
col4_end_date
col4DegreeDate
col4_degree_date
col4DegreeObtained
col4_degree_obtained
collegeName
college_name
districtName
district_name
termCode
term_code
termDescription
term_description
majorCode
major_code
majorDescription
major_description
tstmpSubmit
tstmp_submit
tstmpCreate
tstmp_create
tstmpUpdate
tstmp_update
ssnDisplay
ssn_display
fosterYouthStatus
foster_youth_status
fosterYouthPreference
foster_youth_preference
fosterYouthMis
foster_youth_mis
fosterYouthPriority
foster_youth_priority
tstmpDownload
tstmp_download
addressValidation
address_validation
zip4
zip4
permAddressValidation
perm_address_validation
permZip4
perm_zip4
dischargeType
discharge_type
collegeExpelledSummary
college_expelled_summary
col1ExpelledStatus
col1_expelled_status
col2ExpelledStatus
col2_expelled_status
col3ExpelledStatus
col3_expelled_status
col4ExpelledStatus
col4_expelled_status
integrityFlags
integrity_flags
rdd
rdd
ssnType
ssn_type
militaryStationedCaEd
military_stationed_ca_ed
integrityFg65
integrity_fg_65
integrityFg64
integrity_fg_64
ipAddress
ip_address
campaign1
campaign1
campaign2
campaign2
campaign3
campaign3
orientation
orientation
transgender
transgender
ssnException
ssn_exception
integrityFg71
integrity_fg_71
preferredFirstname
preferred_firstname
preferredMiddlename
preferred_middlename
preferredLastname
preferred_lastname
preferredName
preferred_name
ssnNo
ssn_no
completedEleventhGrade
completed_eleventh_grade
NO LONGER USED
gradePointAverage
grade_point_average
highestEnglishCourse
highest_english_course
highestEnglishGrade
highest_english_grade
highestMathCourseTaken
highest_math_course_taken
highestMathTakenGrade
highest_math_taken_grade
highestMathCoursePassed
highest_math_course_passed
highestMathPassedGrade
highest_math_passed_grade
integrityFg30
integrity_fg_30
hsCdsFull
hs_cds_full
col1CdsFull
col1_cds_full
col2CdsFull
col2_cds_full
col3CdsFull
col3_cds_full
col4CdsFull
col4_cds_full
ssid
ssid
noPermAddressHomeless
no_perm_address_homeless
noMailingAddressHomeless
no_mailing_address_homeless
termStart
term_start
termEnd
term_end
homelessYouth
homeless_youth
integrityFg40
integrity_fg_40
cipCode
cip_code
majorCategory
major_category
mainphoneintl
mainphoneintl
No Longer Used
secondphoneintl
secondphoneintl
No Longer Used
nonCredit
non_credit
integrityFg81
integrity_fg_81
highestGradeCompleted
highest_grade_completed
emailVerified
email_verified
SG v.4.7
emailVerifiedTimestamp
email_verified_timestamp
SG v.4.7
mainphoneVerified
phone_verified
SG v.4.7
mainphoneVerifiedTimestamp
phone_verified_timestamp
SG v.4.7
preferredMethodOfContact
preferred_contact_method
SG v.4.7
addressValidationOverride
address_validation_override
SG v.4.7
addressValidationOverrideTimestamp
address_validation_override_timestamp
date timestamp | 255 | SZRAPLY | acceptedTermsTimestamp | |||
ack_fin_aid | ackFinAid | boolean | SZRAPLY | ackFinAid | ||
address_same | addressSame | boolean | SZRAPLY | addressSame | ||
address_validation | addressValidation | character | 1 | SZRAPLY | addressValidation | |
address_validation_override | addressValidationOverride | boolean | 1 | SZRAPLY | addressValidationOverride | |
address_validation_override_timestamp | addressValidationOverrideTimestamp | date timestamp | 255 | SZRAPLY | addressValidationOverrideTimestamp | |
adm_ineligible | admIneligible | smallint | SZRAPLY | admIneligible | ||
alien_reg_expire_date | alienRegExpireDate | date | SZRAPLY | alienRegExpireDate | ||
alien_reg_issue_date | alienRegIssueDate | date | SZRAPLY | alienRegIssueDate | ||
alien_reg_no_expire | alienRegNoExpire | boolean | SZRAPLY | alienRegNoExpire | ||
alien_reg_number | alienRegNumber | Character varying | 20 | SZRAPLY | alienRegNumber | |
app_id | appId | bigint | SZRAPLY | appId | ||
app_lang | appLang | character | 2 | SZRAPLY | appLang | |
athletic_intercollegiate | athleticIntercollegiate | boolean | SZRAPLY | athleticIntercollegiate | ||
athletic_intramural | athleticIntramural | boolean | SZRAPLY | athleticIntramural | ||
athletic_not_interested | athleticNotInterested | boolean | SZRAPLY | athleticNotInterested | ||
basic_skills | basicSkills | boolean | SZRAPLY | basicSkills | ||
birthdate | birthdate | date | SZRAPLY | birthdate | ||
ca_college_employee | caCollegeEmployee | boolean | SZRAPLY | caCollegeEmployee | ||
ca_date_current | caDateCurrent | date | SZRAPLY | caDateCurrent | ||
ca_foster_youth | caFosterYouth | boolean | SZRAPLY | caFosterYouth | ||
ca_not_arrived | caNotArrived | boolean | SZRAPLY | caNotArrived | ||
ca_outside_college | caOutsideCollege | boolean | SZRAPLY | caOutsideCollege | ||
ca_outside_college_year | caOutsideCollegeYear | date | SZRAPLY | caOutsideCollegeYear | ||
ca_outside_lawsuit | caOutsideLawsuit | boolean | SZRAPLY | caOutsideLawsuit | ||
ca_outside_lawsuit_year | caOutsideLawsuitYear | date | SZRAPLY | caOutsideLawsuitYear | ||
ca_outside_tax | caOutsideTax | boolean | SZRAPLY | caOutsideTax | ||
ca_outside_tax_year | caOutsideTaxYear | date | SZRAPLY | caOutsideTaxYear | ||
ca_outside_voted | caOutsideVoted | boolean | SZRAPLY | caOutsideVoted | ||
ca_outside_voted_year | caOutsideVotedYear | date | SZRAPLY | caOutsideVotedYear | ||
ca_res_2_years | caRes2Years | boolean | SZRAPLY | caRes2Years | ||
ca_school_employee | caSchoolEmployee | boolean | SZRAPLY | caSchoolEmployee | ||
ca_seasonal_ag | caSeasonalAg | boolean | SZRAPLY | caSeasonalAg | ||
cahs_3year | cahs3year | boolean | SZRAPLY | cahs3year | ||
cahs_graduated | cahsGraduated | 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 | |
cap_major_id | N/A | NOT USED | bigint | N/A | N/A | |
cap_term_id | N/A | NOT USED | bigint | N/A | N/A | |
career_planning | careerPlanning | boolean | SZRAPLY | careerPlanning | ||
ccc_id | cccId | character varying | 8 | SZRAPLY | cccId | |
ccgi_token | N/A | RESTRICTED | character varying | 256 | N/A | N/A |
child_care | childCare | boolean | SZRAPLY | childCare | ||
cip_code | cipCode | character | 6 | SZRAPLY | cipCode | |
citizenship_status | citizenshipStatus | character | 1 | SZRAPLY | citizenshipStatus | |
city | city | character varying | 50 | SZRAPLY | city | |
coenroll_confirm | coenrollConfirm | boolean | SZRAPLY | coenrollConfirm | ||
col1_cds | col1Cds | character | 6 | SZRAPLY | col1Cds | |
col1_cds_full | col1CdsFull | Character varying | 14 | SZRAPLY | col1CdsFull | |
col1_ceeb | col1Ceeb | character | 7 | SZRAPLY | col1Ceeb | |
col1_city | col1City | character varying | 20 | SZRAPLY | col1City | |
col1_country | col1Country | character | 2 | SZRAPLY | col1Country | |
col1_degree_date | col1DegreeDate | date | SZRAPLY | col1DegreeDate | ||
col1_degree_obtained | col1DegreeObtained | character | 1 | SZRAPLY | col1DegreeObtained | |
col1_end_date | col1EndDate | date | SZRAPLY | col1EndDate | ||
col1_expelled_status | col1ExpelledStatus | boolean | SZRAPLY | col1ExpelledStatus | ||
col1_name | col1Name | character varying | 30 | SZRAPLY | col1Name | |
col1_not_listed | col1NotListed | boolean | SZRAPLY | col1NotListed | ||
col1_start_date | col1StartDate | date | SZRAPLY | col1StartDate | ||
col1_state | col1State | character varying | 30 | SZRAPLY | col1State | |
col2_cds | col2Cds | character | 6 | SZRAPLY | col2Cds | |
col2_cds_full | col2CdsFull | Character varying | 14 | SZRAPLY | col2CdsFull | |
col2_ceeb | col2Ceeb | character | 7 | SZRAPLY | col2Ceeb | |
col2_city | col2City | character varying | 20 | SZRAPLY | col2City | |
col2_country | col2Country | character | 2 | SZRAPLY | col2Country | |
col2_degree_date | col2DegreeDate | date | SZRAPLY | col2DegreeDate | ||
col2_degree_obtained | col2DegreeObtained | character | 1 | SZRAPLY | col2DegreeObtained | |
col2_end_date | col2EndDate | date | SZRAPLY | col2EndDate | ||
col2_expelled_status | col2ExpelledStatus | boolean | SZRAPLY | col2ExpelledStatus | ||
col2_name | col2Name | character varying | 30 | SZRAPLY | col2Name | |
col2_not_listed | col2NotListed | boolean | SZRAPLY | col2NotListed | ||
col2_start_date | col2StartDate | date | SZRAPLY | col2StartDate | ||
col2_state | col2State | character varying | 30 | SZRAPLY | col2State | |
col3_cds | col3Cds | character | 6 | SZRAPLY | col3Cds | |
col3_cds_full | col3CdsFull | Character varying | 14 | SZRAPLY | col3CdsFull | |
col3_ceeb | col3Ceeb | character | 7 | SZRAPLY | col3Ceeb | |
col3_city | col3City | character varying | 20 | SZRAPLY | col3City | |
col3_country | col3Country | character | 2 | SZRAPLY | col3Country | |
col3_degree_date | col3DegreeDate | date | SZRAPLY | col3DegreeDate | ||
col3_degree_obtained | col3DegreeObtained | character | 1 | SZRAPLY | col3DegreeObtained | |
col3_end_date | col3EndDate | date | SZRAPLY | col3EndDate | ||
col3_expelled_status | col3ExpelledStatus | boolean | SZRAPLY | col3ExpelledStatus | ||
col3_name | col3Name | character varying | 30 | SZRAPLY | col3Name | |
col3_not_listed | col3NotListed | boolean | SZRAPLY | col3NotListed | ||
col3_start_date | col3StartDate | date | SZRAPLY | col3StartDate | ||
col3_state | col3State | character varying | 30 | SZRAPLY | col3State | |
col4_cds | col4Cds | character | 6 | SZRAPLY | col4Cds | |
col4_cds_full | col4CdsFull | Character varying | 14 | SZRAPLY | col4CdsFull | |
col4_ceeb | col4Ceeb | character | 7 | SZRAPLY | col4Ceeb | |
col4_city | col4City | character varying | 20 | SZRAPLY | col4City | |
col4_country | col4Country | character | 2 | SZRAPLY | col4Country | |
col4_degree_date | col4DegreeDate | date | SZRAPLY | col4DegreeDate | ||
col4_degree_obtained | col4DegreeObtained | character | 1 | SZRAPLY | col4DegreeObtained | |
col4_end_date | col4EndDate | date | SZRAPLY | col4EndDate | ||
col4_expelled_status | col4ExpelledStatus | boolean | SZRAPLY | col4ExpelledStatus | ||
col4_name | col4Name | character varying | 30 | SZRAPLY | col4Name | |
col4_not_listed | col4NotListed | boolean | SZRAPLY | col4NotListed | ||
col4_start_date | col4StartDate | date | SZRAPLY | col4StartDate | ||
col4_state | col4State | character varying | 30 | SZRAPLY | col4State | |
college_count | collegeCount | smallint | SZRAPLY | collegeCount | ||
college_expelled_summary | collegeExpelledSummary | boolean | SZRAPLY | collegeExpelledSummary | ||
college_id | collegeId | character | 3 | SZRAPLY | collegeId | |
college_name | collegeName | character varying | 50 | SZRAPLY | collegeName | |
comfortable_english | comfortableEnglish | boolean | SZRAPLY | comfortableEnglish | ||
comments | comments | text | 50 | SZRAPLY | comments | |
completed_eleventh_grade | completedEleventhGrade | NO LONGER USED | boolean | SZRAPLY | completedEleventhGrade | |
confirmation | confirmation | character varying | 30 | SZRAPLY | confirmation | |
consent_indicator | consentIndicator | boolean | SZRAPLY | consentIndicator | ||
counseling_personal | counselingPersonal | boolean | SZRAPLY | counselingPersonal | ||
country | country | character | 2 | SZRAPLY | country | |
cryptokeyid | N/A | RESTRICTED USE | integer | N/A | N/A | |
dependent_status | dependentStatus | character | 1 | SZRAPLY | dependentStatus | |
discharge_type | dischargeType | character varying | 1 | SZRAPLY | dischargeType | |
district_name | districtName | character varying | 50 | SZRAPLY | districtName | |
dsps | dsps | boolean | SZRAPLY | dsps | ||
edu_goal | eduGoal | character | 1 | SZRAPLY | eduGoal | |
elig_ab540 | eligAb540 | boolean | SZRAPLY | eligAb540 | ||
character varying | 254 | SZRAPLY | ||||
email_verified | emailVerified | boolean | SZRAPLY | emailVerified | ||
email_verified_timestamp | emailVerifiedTimestamp | timestamp with time zone | 255 | SZRAPLY | emailVerifiedTimestamp | |
employment_assistance | employmentAssistance | boolean | SZRAPLY | employmentAssistance | ||
enroll_status | enrollStatus | character | 1 | SZRAPLY | enrollStatus | |
eops | eops | boolean | SZRAPLY | eops | ||
esignature | N/A | NO LONGER IN USE | boolean | N/A | N/A | |
esl | esl | boolean | SZRAPLY | esl | ||
experience | experience | integer | 1 | SZRAPLY | experience | |
fin_aid_ref | finAidRef | boolean | SZRAPLY | finAidRef | ||
financial_assistance | financialAssistance | boolean | SZRAPLY | financialAssistance | ||
firstname | firstname | character varying | 50 | SZRAPLY | firstname | |
foster_youth_mis | fosterYouthMis | boolean | SZRAPLY | fosterYouthMis | ||
foster_youth_preference | fosterYouthPreference | boolean | SZRAPLY | fosterYouthPreference | ||
foster_youth_priority | fosterYouthPriority | boolean | SZRAPLY | fosterYouthPriority | ||
foster_youth_status | fosterYouthStatus | character | 1 | SZRAPLY | fosterYouthStatus | |
foster_youths | fosterYouths | NO LONGER IN USE | boolean | SZRAPLY | fosterYouths | |
fraud_score | fraudScore | double precision | SZRAPLY | fraudScore | ||
fraud_status | fraudStatus | integer | SZRAPLY | fraudStatus | ||
gender | gender | character | 1 | SZRAPLY | gender | |
grade_point_average | gradePointAverage | Alphanumeric | 5 | SZRAPLY | gradePointAverage | |
health_services | healthServices | boolean | SZRAPLY | healthServices | ||
higher_comp_date | higherCompDate | date | SZRAPLY | higherCompDate | ||
higher_edu_level | higherEduLevel | character | 1 | SZRAPLY | higherEduLevel | |
highest_edu_level | highestEduLevel | character | 5 | SZRAPLY | highestEduLevel | |
highest_english_course | highestEnglishCourse | Integer | SZRAPLY | highestEnglishCourse | ||
highest_english_grade | highestEnglishGrade | Character varying | 2 | SZRAPLY | highestEnglishGrade | |
highest_grade_completed | highestGradeCompleted | varchar | 2 | SZRAPLY | highestGradeCompleted | |
highest_math_course_passed | highestMathCoursePassed | Integer | SZRAPLY | highestMathCoursePassed | ||
highest_math_course_taken | highestMathCourseTaken | Integer | SZRAPLY | highestMathCourseTaken | ||
highest_math_passed_grade | highestMathPassedGrade | Character varying | 2 | SZRAPLY | highestMathPassedGrade | |
highest_math_taken_grade | highestMathTakenGrade | Character varying | 2 | SZRAPLY | highestMathTakenGrade | |
hispanic | hispanic | boolean | SZRAPLY | hispanic | ||
homeless_youth | homelessYouth | boolean | SZRAPLY | homelessYouth | ||
home_schooled | homeSchooled | NOT IN USE | Boolean | SZRAPLY | homeSchooled | |
housing_info | housingInfo | boolean | SZRAPLY | housingInfo | ||
hs_attendance | hsAttendance | smallint | SZRAPLY | hsAttendance | ||
hs_cds | hsCds | character | 6 | SZRAPLY | hsCds | |
hs_cds_full | hsCdsFull | Character varying | 14 | SZRAPLY | hsCdsFull | |
hs_ceeb | hsCeeb | character | 7 | SZRAPLY | hsCeeb | |
hs_city | hsCity | character varying | 20 | SZRAPLY | hsCity | |
hs_comp_date | hsCompDate | date | SZRAPLY | hsCompDate | ||
hs_country | hsCountry | character | 2 | SZRAPLY | hsCountry | |
hs_edu_level | hsEduLevel | character | 1 | SZRAPLY | hsEduLevel | |
hs_name | hsName | character varying | 30 | SZRAPLY | hsName | |
hs_not_attended | hsNotAttended | boolean | SZRAPLY | hsNotAttended | ||
hs_not_listed | hsNotListed | boolean | SZRAPLY | hsNotListed | ||
hs_state | hsState | character | 2 | SZRAPLY | hsState | |
integrity_fg_01 | integrityFg01 | boolean | SZRAPLY | integrityFg01 | ||
integrity_fg_02 | integrityFg02 | boolean | SZRAPLY | integrityFg02 | ||
integrity_fg_03 | integrityFg03 | boolean | SZRAPLY | integrityFg03 | ||
integrity_fg_04 | integrityFg04 | boolean | SZRAPLY | integrityFg04 | ||
integrity_fg_11 | integrityFg11 | boolean | SZRAPLY | integrityFg11 | ||
integrity_fg_30 | integrityFg30 | Boolean | SZRAPLY | integrityFg30 | ||
Integrity_fg_40 | integrityFg40 | boolean | SZRAPLY | integrityFg40 | ||
Integrity_fg_41 | N/A | boolean | N/A | N/A | ||
integrity_fg_47 | integrityFg47 | boolean | SZRAPLY | integrityFg47 | ||
integrity_fg_48 | integrityFg48 | boolean | SZRAPLY | integrityFg48 | ||
integrity_fg_49 | integrityFg49 | boolean | SZRAPLY | integrityFg49 | ||
integrity_fg_50 | integrityFg50 | boolean | SZRAPLY | integrityFg50 | ||
integrity_fg_51 | integrityFg51 | boolean | SZRAPLY | integrityFg51 | ||
integrity_fg_52 | integrityFg52 | boolean | SZRAPLY | integrityFg52 | ||
integrity_fg_53 | integrityFg53 | boolean | SZRAPLY | integrityFg53 | ||
integrity_fg_54 | integrityFg54 | boolean | SZRAPLY | integrityFg54 | ||
integrity_fg_55 | integrityFg55 | boolean | SZRAPLY | integrityFg55 | ||
integrity_fg_56 | integrityFg56 | boolean | SZRAPLY | integrityFg56 | ||
integrity_fg_57 | integrityFg57 | boolean | SZRAPLY | integrityFg57 | ||
integrity_fg_58 | integrityFg58 | boolean | SZRAPLY | integrityFg58 | ||
integrity_fg_59 | integrityFg59 | boolean | SZRAPLY | integrityFg59 | ||
integrity_fg_60 | integrityFg60 | boolean | SZRAPLY | integrityFg60 | ||
integrity_fg_61 | integrityFg61 | boolean | SZRAPLY | integrityFg61 | ||
integrity_fg_62 | integrityFg62 | boolean | SZRAPLY | integrityFg62 | ||
integrity_fg_63 | integrityFg63 | boolean | SZRAPLY | integrityFg63 | ||
integrity_fg_64 | integrityFg64 | boolean | SZRAPLY | integrityFg64 | ||
integrity_fg_65 | integrityFg65 | boolean | SZRAPLY | integrityFg65 | ||
integrity_fg_70 | integrityFg70 | boolean | SZRAPLY | integrityFg70 | ||
integrity_fg_71 | integrityFg71 | boolean | SZRAPLY | integrityFg71 | ||
integrity_fg_80 | integrityFg80 | boolean | SZRAPLY | integrityFg80 | ||
Integrity_fg_81 | integrityFg81 | boolean | SZRAPLY | integrityFg81 | ||
integrity_flags | integrityFlags | character varying | 255 | SZRAPLY | integrityFlags | |
intended_major | intendedMajor | character varying | 30 | SZRAPLY | intendedMajor | |
ip_address | ipAddress | character varying | 15 | SZRAPLY | ipAddress | |
ip_address_at_account_creation | ipAddressAtAccountCreation | v SG 4.6 | character varying | 40 | SZRAPLY | ipAddressAtAccountCreation |
ip_address_at_app_creation | ipAddressAtAppCreation | v SG 4.6 | character varying | 40 | SZRAPLY | ipAddressAtAppCreation |
last_page | lastname | character varying | 25 | SZRAPLY | lastname | |
lastname | lastPage | character varying | 50 | SZRAPLY | lastPage | |
mailing_address_validation_override | mailingAddressValidationOverride | v SG 4.6 | boolean | SZRAPLY | mailingAddressValidationOverride | |
mainphone | mainphone | character varying | 19 | SZRAPLY | mainphone | |
mainphone_auth_text | mainphoneAuthText | NO LONGER IN USE | boolean | SZRAPLY | mainphoneAuthText | |
mainphone_ext | mainphoneExt | NO LONGER IN USE | character varying | 4 | SZRAPLY | mainphoneExt |
mainphoneintl | mainphoneintl | NO LONGER IN USE | character varying | 25 | SZRAPLY | mainphoneintl |
major_category | majorCategory | character varying | 100 | SZRAPLY | majorCategory | |
major_code | majorCode | character varying | 30 | SZRAPLY | majorCode | |
major_description | majorDescription | character varying | 100 | SZRAPLY | majorDescription | |
major_id | majorId | SYSTEM USE ONLY | bigint | SZRAPLY | majorId | |
middlename | middlename | character varying | 50 | SZRAPLY | middlename | |
military_ca_stationed | militaryCaStationed | boolean | SZRAPLY | militaryCaStationed | ||
military_discharge_date | militaryDischargeDate | date | SZRAPLY | militaryDischargeDate | ||
military_home_country | militaryHomeCountry | character | 2 | SZRAPLY | militaryHomeCountry | |
military_home_state | militaryHomeState | character | 2 | SZRAPLY | militaryHomeState | |
military_legal_residence | militaryLegalResidence | character | 2 | SZRAPLY | militaryLegalResidence | |
military_stationed_ca_ed | militaryStationedCaEd | boolean | SZRAPLY | militaryStationedCaEd | ||
military_status | militaryStatus | character | 1 | SZRAPLY | militaryStatus | |
military_veteran_consent | N/A | RESTRICTED USE | boolean | N/A | N/A | |
no_documents | noDocuments | boolean | SZRAPLY | noDocuments | ||
no_mailing_address_homeless | noMailingAddressHomeless | boolean | SZRAPLY | noMailingAddressHomeless | ||
no_perm_address_homeless | noPermAddressHomeless | boolean | SZRAPLY | noPermAddressHomeless | ||
non_credit | nonCredit | boolean | SZRAPLY | nonCredit | ||
non_us_address | nonUsAddress | boolean | SZRAPLY | nonUsAddress | ||
nonusaprovince | nonusaprovince | character varying | 30 | SZRAPLY | nonusaprovince | |
online_classes | onlineClasses | boolean | SZRAPLY | onlineClasses | ||
orientation | orientation | RESTRICTED USE | byte | 1 | SZRAPLY | orientation |
orientation_encrypted | N/A | 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 | |
perm_address_validation | permAddressValidation | character | 1 | SZRAPLY | permAddressValidation | |
perm_city | permCity | character varying | 50 | SZRAPLY | permCity | |
perm_country | permCountry | character | 2 | SZRAPLY | permCountry | |
perm_nonusaprovince | permNonusaprovince | character varying | 30 | SZRAPLY | permNonusaprovince | |
perm_postalcode | permPostalcode | character varying | 20 | SZRAPLY | permPostalcode | |
perm_state | permState | character | 2 | SZRAPLY | permState | |
perm_streetaddress1 | permStreetaddress1 | character varying | 50 | SZRAPLY | permStreetaddress1 | |
perm_streetaddress2 | permStreetaddress2 | character varying | 50 | SZRAPLY | permStreetaddress2 | |
perm_zip4 | permZip4 | character | 4 | SZRAPLY | permZip4 | |
pg_edu_mis | pgEduMis | character | 2 | SZRAPLY | pgEduMis | |
pg_firstname | pgFirstname | character varying | 20 | SZRAPLY | pgFirstname | |
pg_lastname | pgLastname | character varying | 25 | SZRAPLY | pgLastname | |
pg_rel | pgRel | character | 1 | SZRAPLY | pgRel | |
pg1_edu | pg1Edu | character | 1 | SZRAPLY | pg1Edu | |
pg2_edu | pg2Edu | character | 1 | SZRAPLY | pg2Edu | |
phone_type | phoneType | v SG 4.6 | varchar | 10 | SZRAPLY | phoneType |
phone_verified | phoneVerified | Boolean | SZRAPLY | phoneVerified | ||
phone_verified_timestamp | phoneVerifiedTimestamp | timestamp with time zone | SZRAPLY | phoneVerifiedTimestamp | ||
postalcode | postalcode | character varying | 20 | SZRAPLY | postalcode | |
preferred_contact_method | preferredMethodOfContact | VarChar | 10 | SZRAPLY | preferredMethodOfContact | |
preferred_firstname | preferredFirstname | Text string | 50 | SZRAPLY | preferredFirstname | |
preferred_lastname | preferredLastname | NO LONGER IN USE | character varying | 50 | SZRAPLY | preferredLastname |
preferred_middlename | preferredMiddlename | NO LONGER IN USE | character varying | 50 | SZRAPLY | preferredMiddlename |
preferred_name | preferredName | NO LONGER IN USE | boolean | 1 | SZRAPLY | preferredName |
race_ethnic | raceEthnic | text | SZRAPLY | raceEthnic | ||
race_ethnic_full | raceEthnicFull | text | 805 | SZRAPLY | raceEthnicFull | |
race_group | raceGroup | text | SZRAPLY | raceGroup | ||
rdd | rdd | date | SZRAPLY | rdd | ||
recommend | recommend | integer | 1 | SZRAPLY | recommend | |
reentry_program | reentryProgram | boolean | SZRAPLY | reentryProgram | ||
res_area_a | resAreaA | smallint | SZRAPLY | resAreaA | ||
res_area_b | resAreaB | smallint | SZRAPLY | resAreaB | ||
res_area_c | resAreaC | smallint | SZRAPLY | resAreaC | ||
res_area_d | resAreaD | smallint | SZRAPLY | resAreaD | ||
res_prev_date | resPrevDate | date | SZRAPLY | resPrevDate | ||
res_status | resStatus | character | 1 | SZRAPLY | resStatus | |
res_status_change | resStatusChange | boolean | SZRAPLY | resStatusChange | ||
salt | N/A | SYSTEM USE ONLY | text | N/A | N/A | |
scholarship_info | scholarshipInfo | boolean | SZRAPLY | scholarshipInfo | ||
secondphone_auth_text | secondphoneAuthText | NO LONGER IN USE | boolean | SZRAPLY | secondphoneAuthText | |
secondphone_ext | secondphoneExt | 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 | |||
sis_receipt | sisReceipt | boolean | SZRAPLY | sisReceipt | ||
ssid | ssid | character varying | 10 | SZRAPLY | ssid | |
ssn | ssn | RESTRICTED USE | text | 11 | SZRAPLY | ssn |
ssn_display | ssnDisplay | character varying | 11 | SZRAPLY | ssnDisplay | |
ssn_exception | ssnException | boolean | SZRAPLY | ssnException | ||
ssn_no | ssnNo | character | SZRAPLY | ssnNo | ||
ssn_type | ssnType | 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 | |
student_government | studentGovernment | boolean | SZRAPLY | studentGovernment | ||
student_parent | studentParent | Coming SG 4.7 | boolean | SZRAPLY | studentParent | |
suffix | suffix | character varying | 3 | SZRAPLY | suffix | |
sup_page_code | supPageCode | NO LONGER IN USE | character varying | 30 | SZRAPLY | supPageCode |
tanf_ssi_ga | tanfSsiGa | boolean | SZRAPLY | tanfSsiGa | ||
term_code | termCode | character varying | 15 | SZRAPLY | termCode | |
term_description | termDescription | character varying | 100 | SZRAPLY | termDescription | |
term_id | termId | SYSTEM USE ONLY | bigint | SZRAPLY | termId | |
term_end | termEnd | date | 13 | SZRAPLY | termEnd | |
term_start | termStart | date | 13 | SZRAPLY | termStart | |
testing_assessment | testingAssessment | boolean | SZRAPLY | testingAssessment | ||
transfer_info | transferInfo | boolean | SZRAPLY | transferInfo | ||
transgender | transgender | RESTRICTED USE | Byte | 1 | SZRAPLY | transgender |
transgender_encrypted | N/A | RESTRICTED USE | N/A | N/A | ||
tstmp_create | tstmpCreate | timestamp with time zone | SZRAPLY | tstmpCreate | ||
tstmp_download | tstmpDownload | timestamp with time zone | SZRAPLY | tstmpDownload | ||
tstmp_submit | tstmpSubmit | timestamp with time zone | SZRAPLY | tstmpSubmit | ||
tstmp_update | tstmpUpdate | timestamp with time zone | SZRAPLY | tstmpUpdate | ||
tutoring_services | tutoringServices | boolean | SZRAPLY | tutoringServices | ||
under19_ind | under19Ind | boolean | SZRAPLY | under19Ind | ||
veterans_services | veteransServices | boolean | SZRAPLY | veteransServices | ||
visa_type | visaType | alphanumeric | 2 | SZRAPLY | visaType | |
zip4 | zip4 | character | 4 | SZRAPLY | zip4 |
Supplemental Questions Data Fields Mappings - MSQL
...
College Adaptor Payload Name | CCC Field Name | DB Staging Table | Field College Adaptor Payload Name | Notes |
---|---|---|---|---|
appId | app_idAPP_ID | SZRAPLY | appId | |
suppText01 | supp_text_01SUPP_TEXT_01 | SZRAPLY | suppText01 | |
suppText02 | supp_text_02SUPP_TEXT_02 | SZRAPLY | suppText02 | |
suppText03 | supp_text_03SUPP_TEXT_03 | SZRAPLY | suppText03 | |
suppText04 | supp_text_04SUPP_TEXT_04 | SZRAPLY | suppText04 | |
suppText05 | supp_text_05SUPP_TEXT_05 | SZRAPLY | suppText05 | |
suppText06 | supp_text_06SUPP_TEXT_06 | SZRAPLY | suppText06 | |
suppText07 | supp_text_07SUPP_TEXT_07 | SZRAPLY | suppText07 | |
suppText08 | supp_text_08SUPP_TEXT_08 | SZRAPLY | suppText08 | |
suppText09 | supp_text_09SUPP_TEXT_09 | SZRAPLY | suppText09 | |
suppText10 | supp_text_10SUPP_TEXT_10 | SZRAPLY | suppText10 | |
suppText11 | supp_text_11SUPP_TEXT_11 | SZRAPLY | suppText11 | |
suppText12 | supp_text_12SUPP_TEXT_12 | SZRAPLY | suppText12 | |
suppText13 | supp_text_13SUPP_TEXT_13 | SZRAPLY | suppText13 | |
suppText14 | supp_text_14SUPP_TEXT_14 | SZRAPLY | suppText14 | |
suppText15 | supp_text_15SUPP_TEXT_15 | SZRAPLY | suppText15 | |
suppText16 | supp_text_16SUPP_TEXT_16 | SZRAPLY | suppText16 | |
suppText17 | supp_text_17SUPP_TEXT_17 | SZRAPLY | suppText17 | |
suppText18 | supp_text_18SUPP_TEXT_18 | SZRAPLY | suppText18 | |
suppText19 | supp_text_19SUPP_TEXT_19 | SZRAPLY | suppText19 | |
suppText20 | supp_text_20SUPP_TEXT_20 | SZRAPLY | suppText20 | |
suppCheck01 | supp_check_01SUPP_CHECK_01 | SZRAPLY | suppCheck01 | |
suppCheck02 | supp_check_02SUPP_CHECK_02 | SZRAPLY | suppCheck02 | |
suppCheck03 | supp_check_03SUPP_CHECK_03 | SZRAPLY | suppCheck03 | |
suppCheck04 | supp_check_04SUPP_CHECK_04 | SZRAPLY | suppCheck04 | |
suppCheck05 | supp_check_05SUPP_CHECK_05 | SZRAPLY | suppCheck05 | |
suppCheck06 | supp_check_06SUPP_CHECK_06 | SZRAPLY | suppCheck06 | |
suppCheck07 | supp_check_07SUPP_CHECK_07 | SZRAPLY | suppCheck07 | |
suppCheck08 | supp_check_08SUPP_CHECK_08 | SZRAPLY | suppCheck08 | |
suppCheck09 | supp_check_09SUPP_CHECK_09 | SZRAPLY | suppCheck09 | |
suppCheck10 | supp_check_10SUPP_CHECK_10 | SZRAPLY | suppCheck10 | |
suppCheck11 | supp_check_11SUPP_CHECK_11 | SZRAPLY | suppCheck11 | |
suppCheck12 | supp_check_12SUPP_CHECK_12 | SZRAPLY | suppCheck12 | |
suppCheck13 | supp_check_13SUPP_CHECK_13 | SZRAPLY | suppCheck13 | |
suppCheck14 | supp_check_14SUPP_CHECK_14 | SZRAPLY | suppCheck14 | |
suppCheck15 | supp_check_15SUPP_CHECK_15 | SZRAPLY | suppCheck15 | |
suppCheck16 | supp_check_16SUPP_CHECK_16 | SZRAPLY | suppCheck16 | |
suppCheck17 | supp_check_17SUPP_CHECK_17 | SZRAPLY | suppCheck17 | |
suppCheck18 | supp_check_18SUPP_CHECK_18 | SZRAPLY | suppCheck18 | |
suppCheck19 | supp_check_19SUPP_CHECK_19 | SZRAPLY | suppCheck19 | |
suppCheck20 | supp_check_20SUPP_CHECK_20 | SZRAPLY | suppCheck20 | |
suppCheck21 | supp_check_21SUPP_CHECK_21 | SZRAPLY | suppCheck21 | |
suppCheck22 | supp_check_22SUPP_CHECK_22 | SZRAPLY | suppCheck22 | |
suppCheck23 | supp_check_23SUPP_CHECK_23 | SZRAPLY | suppCheck23 | |
suppCheck24 | supp_check_24SUPP_CHECK_24 | SZRAPLY | suppCheck24 | |
suppCheck25 | supp_check_25SUPP_CHECK_25 | SZRAPLY | suppCheck25 | |
suppCheck26 | supp_check_26SUPP_CHECK_26 | SZRAPLY | suppCheck26 | |
suppCheck27 | supp_check_27SUPP_CHECK_27 | SZRAPLY | suppCheck27 | |
suppCheck28 | supp_check_28SUPP_CHECK_28 | SZRAPLY | suppCheck28 | |
suppCheck29 | supp_check_29SUPP_CHECK_29 | SZRAPLY | suppCheck29 | |
suppCheck30 | supp_check_30SUPP_CHECK_30 | SZRAPLY | suppCheck30 | |
suppCheck31 | supp_check_31SUPP_CHECK_31 | SZRAPLY | suppCheck31 | |
suppCheck32 | supp_check_32SUPP_CHECK_32 | SZRAPLY | suppCheck32 | |
suppCheck33 | supp_check_33SUPP_CHECK_33 | SZRAPLY | suppCheck33 | |
suppCheck34 | supp_check_34SUPP_CHECK_34 | SZRAPLY | suppCheck34 | |
suppCheck35 | supp_check_35SUPP_CHECK_35 | SZRAPLY | suppCheck35 | |
suppCheck36 | supp_check_36SUPP_CHECK_36 | SZRAPLY | suppCheck36 | |
suppCheck37 | supp_check_37SUPP_CHECK_37 | SZRAPLY | suppCheck37 | |
suppCheck38 | supp_check_38SUPP_CHECK_38 | SZRAPLY | suppCheck38 | |
suppCheck39 | supp_check_39SUPP_CHECK_39 | SZRAPLY | suppCheck39 | |
suppCheck40 | supp_check_40SUPP_CHECK_40 | SZRAPLY | suppCheck40 | |
suppCheck41 | supp_check_41SUPP_CHECK_41 | SZRAPLY | suppCheck41 | |
suppCheck42 | supp_check_42SUPP_CHECK_42 | SZRAPLY | suppCheck42 | |
suppCheck43 | supp_check_43SUPP_CHECK_43 | SZRAPLY | suppCheck43 | |
suppCheck44 | supp_check_44SUPP_CHECK_44 | SZRAPLY | suppCheck44 | |
suppCheck45 | supp_check_45SUPP_CHECK_45 | SZRAPLY | suppCheck45 | |
suppCheck46 | supp_check_46SUPP_CHECK_46 | SZRAPLY | suppCheck46 | |
suppCheck47 | supp_check_47SUPP_CHECK_47 | SZRAPLY | suppCheck47 | |
suppCheck48 | supp_check_48SUPP_CHECK_48 | SZRAPLY | suppCheck48 | |
suppCheck49 | supp_check_49SUPP_CHECK_49 | SZRAPLY | suppCheck49 | |
suppCheck50 | supp_check_50SUPP_CHECK_50 | SZRAPLY | suppCheck50 | |
suppYesno01 | supp_yesno_01SUPP_YESNO_01 | SZRAPLY | suppYesno01 | |
suppYesno02 | supp_yesno_02SUPP_YESNO_02 | SZRAPLY | suppYesno02 | |
suppYesno03 | supp_yesno_03SUPP_YESNO_03 | SZRAPLY | suppYesno03 | |
suppYesno04 | supp_yesno_04SUPP_YESNO_04 | SZRAPLY | suppYesno04 | |
suppYesno05 | supp_yesno_05SUPP_YESNO_05 | SZRAPLY | suppYesno05 | |
suppYesno06 | supp_yesno_06SUPP_YESNO_06 | SZRAPLY | suppYesno06 | |
suppYesno07 | supp_yesno_07SUPP_YESNO_07 | SZRAPLY | suppYesno07 | |
suppYesno08 | supp_yesno_08SUPP_YESNO_08 | SZRAPLY | suppYesno08 | |
suppYesno09 | supp_yesno_09SUPP_YESNO_09 | SZRAPLY | suppYesno09 | |
suppYesno10 | supp_yesno_10SUPP_YESNO_10 | SZRAPLY | suppYesno10 | |
suppYesno11 | supp_yesno_11SUPP_YESNO_11 | SZRAPLY | suppYesno11 | |
suppYesno12 | supp_yesno_12SUPP_YESNO_12 | SZRAPLY | suppYesno12 | |
suppYesno13 | supp_yesno_13SUPP_YESNO_13 | SZRAPLY | suppYesno13 | |
suppYesno14 | supp_yesno_14SUPP_YESNO_14 | SZRAPLY | suppYesno14 | |
suppYesno15 | supp_yesno_15SUPP_YESNO_15 | SZRAPLY | suppYesno15 | |
suppYesno16 | supp_yesno_16SUPP_YESNO_16 | SZRAPLY | suppYesno16 | |
suppYesno17 | supp_yesno_17SUPP_YESNO_17 | SZRAPLY | suppYesno17 | |
suppYesno18 | supp_yesno_18SUPP_YESNO_18 | SZRAPLY | suppYesno18 | |
suppYesno19 | supp_yesno_19SUPP_YESNO_19 | SZRAPLY | suppYesno19 | |
suppYesno20 | supp_yesno_20SUPP_YESNO_20 | SZRAPLY | suppYesno20 | |
suppYesno21 | supp_yesno_21SUPP_YESNO_21 | SZRAPLY | suppYesno21 | |
suppYesno22 | supp_yesno_22SUPP_YESNO_22 | SZRAPLY | suppYesno22 | |
suppYesno23 | supp_yesno_23SUPP_YESNO_23 | SZRAPLY | suppYesno23 | |
suppYesno24 | supp_yesno_24SUPP_YESNO_24 | SZRAPLY | suppYesno24 | |
suppYesno25 | supp_yesno_25SUPP_YESNO_25 | SZRAPLY | suppYesno25 | |
suppYesno26 | supp_yesno_26SUPP_YESNO_26 | SZRAPLY | suppYesno26 | |
suppYesno27 | supp_yesno_27SUPP_YESNO_27 | SZRAPLY | suppYesno27 | |
suppYesno28 | supp_yesno_28SUPP_YESNO_28 | SZRAPLY | suppYesno28 | |
suppYesno29 | supp_yesno_29SUPP_YESNO_29 | SZRAPLY | suppYesno29 | |
suppYesno30 | supp_yesno_30SUPP_YESNO_30 | SZRAPLY | suppYesno30 | |
suppMenu01 | supp_menu_01SUPP_MENU_01 | SZRAPLY | suppMenu01 | |
suppMenu02 | supp_menu_02SUPP_MENU_02 | SZRAPLY | suppMenu02 | |
suppMenu03 | supp_menu_03SUPP_MENU_03 | SZRAPLY | suppMenu03 | |
suppMenu04 | supp_menu_04SUPP_MENU_04 | SZRAPLY | suppMenu04 | |
suppMenu05 | supp_menu_05SUPP_MENU_05 | SZRAPLY | suppMenu05 | |
suppMenu06 | supp_menu_06SUPP_MENU_06 | SZRAPLY | suppMenu06 | |
suppMenu07 | supp_menu_07SUPP_MENU_07 | SZRAPLY | suppMenu07 | |
suppMenu08 | supp_menu_08SUPP_MENU_08 | SZRAPLY | suppMenu08 | |
suppMenu09 | supp_menu_09SUPP_MENU_09 | SZRAPLY | suppMenu09 | |
suppMenu10 | supp_menu_10SUPP_MENU_10 | SZRAPLY | suppMenu10 | |
suppMenu11 | supp_menu_11SUPP_MENU_11 | SZRAPLY | suppMenu11 | |
suppMenu12 | supp_menu_12SUPP_MENU_12 | SZRAPLY | suppMenu12 | |
suppMenu13 | supp_menu_13SUPP_MENU_13 | SZRAPLY | suppMenu13 | |
suppMenu14 | supp_menu_14SUPP_MENU_14 | SZRAPLY | suppMenu14 | |
suppMenu15 | supp_menu_15SUPP_MENU_15 | SZRAPLY | suppMenu15 | |
suppMenu16 | supp_menu_16SUPP_MENU_16 | SZRAPLY | suppMenu16 | |
suppMenu17 | supp_menu_17SUPP_MENU_17 | SZRAPLY | suppMenu17 | |
suppMenu18 | supp_menu_18SUPP_MENU_18 | SZRAPLY | suppMenu18 | |
suppMenu19 | supp_menu_19SUPP_MENU_19 | SZRAPLY | suppMenu19 | |
suppMenu20 | supp_menu_20SUPP_MENU_20 | SZRAPLY | suppMenu20 | |
suppMenu21 | supp_menu_21SUPP_MENU_21 | SZRAPLY | suppMenu21 | |
suppMenu22 | supp_menu_22SUPP_MENU_22 | SZRAPLY | suppMenu22 | |
suppMenu23 | supp_menu_23SUPP_MENU_23 | SZRAPLY | suppMenu23 | |
suppMenu24 | supp_menu_24SUPP_MENU_24 | SZRAPLY | suppMenu24 | |
suppMenu25 | supp_menu_25SUPP_MENU_25 | SZRAPLY | suppMenu25 | |
suppMenu26 | supp_menu_26SUPP_MENU_26 | SZRAPLY | suppMenu26 | |
suppMenu27 | supp_menu_27SUPP_MENU_27 | SZRAPLY | suppMenu27 | |
suppMenu28 | supp_menu_28SUPP_MENU_28 | SZRAPLY | suppMenu28 | |
suppMenu29 | supp_menu_29SUPP_MENU_29 | SZRAPLY | suppMenu29 | |
suppMenu30 | supp_menu_30SUPP_MENU_30 | SZRAPLY | suppMenu30 | |
suppDate01 | supp_date_01SUPP_DATE_01 | SZRAPLY | suppDate01 | |
suppDate02 | supp_date_02SUPP_DATE_02 | SZRAPLY | suppDate02 | |
suppDate03 | supp_date_03SUPP_DATE_03 | SZRAPLY | suppDate03 | |
suppDate04 | supp_date_04SUPP_DATE_04 | SZRAPLY | suppDate04 | |
suppDate05 | supp_date_05SUPP_DATE_05 | SZRAPLY | suppDate05 | |
suppState01 | supp_state_01SUPP_STATE_01 | SZRAPLY | suppState01 | |
suppState02 | supp_state_02SUPP_STATE_02 | SZRAPLY | suppState02 | |
suppState03 | supp_state_03SUPP_STATE_03 | SZRAPLY | suppState03 | |
suppState04 | supp_state_04SUPP_STATE_04 | SZRAPLY | suppState04 | |
suppState05 | supp_state_05SUPP_STATE_05 | SZRAPLY | suppState05 | |
suppCountry01 | supp_country_01SUPP_COUNTRY_01 | SZRAPLY | suppCountry01 | |
suppCountry02 | supp_country_02SUPP_COUNTRY_02 | SZRAPLY | suppCountry02 | |
suppCountry03 | supp_country_03SUPP_COUNTRY_03 | SZRAPLY | suppCountry03 | |
suppCountry04 | supp_country_04SUPP_COUNTRY_04 | SZRAPLY | suppCountry04 | |
suppCountry05 | supp_country_05SUPP_COUNTRY_05 | SZRAPLY | suppCountry05 | |
suppPhonenumber01 | supp_phonenumber_01SUPP_PHONENUMBER_01 | SZRAPLY | suppPhonenumber01 | |
suppPhonenumber02 | supp_phonenumber_02SUPP_PHONENUMBER_02 | SZRAPLY | suppPhonenumber02 | |
suppPhonenumber03 | supp_phonenumber_03SUPP_PHONENUMBER_03 | SZRAPLY | suppPhonenumber03 | |
suppPhonenumber04 | supp_phonenumber_04SUPP_PHONENUMBER_04 | SZRAPLY | suppPhonenumber04 | |
suppPhonenumber05 | supp_phonenumber_05SUPP_PHONENUMBER_05 | SZRAPLY | suppPhonenumber05 | |
suppSecret01 | supp_secret_01SUPP_SECRET_01 | SZRAPLY | suppSecret01 | |
suppSecret02 | supp_secret_02SUPP_SECRET_02 | SZRAPLY | suppSecret02 | |
suppSecret03 | supp_secret_03SUPP_SECRET_03 | SZRAPLY | suppSecret03 | |
suppSecret04 | supp_secret_04SUPP_SECRET_04 | SZRAPLY | suppSecret04 | |
suppSecret05 | supp_secret_05SUPP_SECRET_05 | SZRAPLY | suppSecret05 |