• Elements

  • Element: County of Residence, SUS - 01055

Page Name

A code to indicate the county in which the reported person resides.

For the Admissions and Student Data Course files: This is the county of residence at the time of first admittance (or on readmission after an absence of more than one term) to the institution.

'NFLA' and 'NUSA' should be coded where appropriate based on state of residency and/or country of residency information available to the institution when county of residency is not Florida.

For APPLICANTS_ADMITS, ENROLLMENTS, and FINANCIAL_AID_DEMO tables: If County of Residence at Time of First Admission is unknown code 'ZZZZ' or '.'. Load programs on these tables will NULL these unknowns.

Load programs on EMPLOYEE_DEMO will NULL value on OPS (01039 PAY_PLAN_NUMBER) and unknowns ('ZZZZ' or '.').



ELEMENT

192001

25-MAY-2018


Associated Submissions, Tables, and Columns

SubmissionAscendingTable NameColumn nameElement IDTab column idTable idSubmission name
Admissions (ADM)APPLICANTS_ADMITS (ADMA)COUNTY_OF_RES4522913Admissions
Degrees Awarded (SIFD)ENROLLMENTS (ENRL)COUNTY_OF_RES4525958Degrees Awarded
Hours to Degree (HTD)ENROLLMENTS (ENRL)COUNTY_OF_RES4525958Hours to Degree
Limited Access Programs (LAP)APPLICANTS_ADMITS (ADMA)COUNTY_OF_RES4522913Limited Access Programs
Salary Category Detail (SCD)EMPLOYEE_DEMO (EDEM)COUNTY_OF_RES45168529Salary Category Detail
Student Financial Aid (SFA)ENROLLMENTS (ENRL)COUNTY_OF_RES4525958Student Financial Aid
Student Instruction (SIF)ENROLLMENTS (ENRL)COUNTY_OF_RES4525958Student Instruction
Student Instruction Preliminary (SIFP)ENROLLMENTS (ENRL)COUNTY_OF_RES4525958Student Instruction Preliminary
Teacher Education (TEF)APPLICANTS_ADMITS (ADMA)COUNTY_OF_RES4522913Teacher Education
University Employee/OPS (EMPL)EMPLOYEE_DEMO (EDEM)COUNTY_OF_RES45168529University Employee/OPS
  • 1 - 10

Allowed Values

Excel code
Code
Description
Grouping
'..
MISSING		-
'00000000Not Required
'ALACALACAlachua
'BAKEBAKEBaker
'BAYBAYBay
'BRADBRADBradford
'BREVBREVBrevard
'BROWBROWBroward
'CALHCALHCalhoun
'CHARCHARCharlotte
'CITRCITRCitrus
'CLAYCLAYClay
'COLLCOLLCollier
'COLUCOLUColumbia
'DADEDADEDade
'DESODESODesoto
'DIXIDIXIDixie
'DUVADUVADuval
'ESCAESCAEscambia
'FLAGFLAGFlagler
'FRANFRANFranklin
'GADSGADSGadsden
'GILCGILCGilchrist
'GLADGLADGlades
'GULFGULFGulf
'HAMIHAMIHamilton
'HARDHARDHardee
'HENDHENDHendry
'HERNHERNHernando
'HIGHHIGHHighlands
Download

Edit Values

Submission CodeAscendingTable nameDiagnostic CodeDiagnostic MessageError LevelError Description
ADMAPPLICANTS_ADMITS0005Invalid Value9Critical Error: may cause submission to be rejected
ADMAPPLICANTS_ADMITS0007Missing8Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
ADMAPPLICANTS_ADMITS5807Tolerance exceeded for missing value9Critical Error: may cause submission to be rejected
ADMAPPLICANTS_ADMITS6013COUNTY_OF_RES is nulled if = 'ZZZZ'1Generated or Modified during SUDS Edit Process
EMPLEMPLOYEE_DEMO5415Missing or Invalid9Critical Error: may cause submission to be rejected
EMPLEMPLOYEE_DEMO6090COUNTY_OF_RES is nulled if = 'ZZZZ'1Generated or Modified during SUDS Edit Process
SCDEMPLOYEE_DEMO6090COUNTY_OF_RES is nulled if = 'ZZZZ'1Generated or Modified during SUDS Edit Process
SFAENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SFAENROLLMENTS6077COUNTY_OF_RES is nulled if = 'ZZZZ'1Generated or Modified during SUDS Edit Process
SFAENROLLMENTS6140COUNTY_OF_RES is nulled if COUNTY_OF_RES = 'ZZZZ' 1Generated or Modified during SUDS Edit Process
SIFENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFENROLLMENTS0007Missing8Allowable Tolerance: a 9-level critical error will be generated if the error occurs at a rate above the allowable level
SIFENROLLMENTS0657When State_Adm is 'FL', County of Residence cannot equal NUSA or NFLA 9Critical Error: may cause submission to be rejected
SIFENROLLMENTS5807Tolerance exceeded for missing value9Critical Error: may cause submission to be rejected
SIFENROLLMENTS6077COUNTY_OF_RES is nulled if = 'ZZZZ'1Generated or Modified during SUDS Edit Process
SIFENROLLMENTS6140COUNTY_OF_RES is nulled if COUNTY_OF_RES = 'ZZZZ' 1Generated or Modified during SUDS Edit Process
SIFDENROLLMENTS0005Invalid Value9Critical Error: may cause submission to be rejected
SIFDENROLLMENTS6077COUNTY_OF_RES is nulled if = 'ZZZZ'1Generated or Modified during SUDS Edit Process
SIFDENROLLMENTS6140COUNTY_OF_RES is nulled if COUNTY_OF_RES = 'ZZZZ' 1Generated or Modified during SUDS Edit Process
SIFPENROLLMENTS5807Tolerance exceeded for missing value9Critical Error: may cause submission to be rejected
SIFPENROLLMENTS6077COUNTY_OF_RES is nulled if = 'ZZZZ'1Generated or Modified during SUDS Edit Process
SIFPENROLLMENTS6140COUNTY_OF_RES is nulled if COUNTY_OF_RES = 'ZZZZ' 1Generated or Modified during SUDS Edit Process
SIFPENROLLMENTS6141COUNTY_OF_RES is nulled if DEMO_DATA_SOURCE = 'SIFP' 1Generated or Modified during SUDS Edit Process
  • 1 - 23

Prior Database Information:

VARCHAR2(4)
CNTYRES
COUNTY_OF_RES
Release 2.0