• 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

Allowed Values

'..
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

Edit Values

Submission CodeAscending
Table name
Diagnostic Code
Diagnostic Message
Error Level
Error 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