DORIS Logo
 Back

  IPEDSClientConfig


Description
Custom configuration properties for IRIS survey processing.

Data includes survey-specific and institution-specific attributes and reporting preferences for IPEDS.

Fields
  acadOrProgReporter   string   
Is the institution an academic reporter/fall cohort, a hybrid reporter or program reporter/full-year cohort?
Additional Notes
Valid values: A = Academic, H = Hybrid, P = Program; Default value (if no record or null value): A
  admAdmissionTestScores   string   
Admissions - Undergraduate admission consideration for Admission Test Scores
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admCollegePrepProgram   string   
Admissions - Undergraduate admission consideration for Completion of College Prep Program
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admDemoOfCompetency   string   
Admissions - Undergraduate admission consideration for Formal Demonstration of Competencies (portfolios, certifications, assessments, etc.)
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admLegacyStatus   string   
Admissions - Undergraduate admission consideration for legacy status
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admOtherTestScores   string   
Admissions - Undergraduate admission consideration for Other Test Scores (ABT, Wonderlic, WISC-III, etc.)
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admPersonalStatement   string   
Admissions - Undergraduate admission consideration for personal statement
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admRecommendation   string   
Admissions - Undergraduate admission consideration for Recommendations
Additional Notes
"Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R"
  admSecSchoolGPA   string   
Admissions - Undergraduate admission consideration for Secondary School GPA
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admSecSchoolRank   string   
Admissions - Undergraduate admission consideration for Secondary School Rank
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admSecSchoolRecord   string   
Admissions - Undergraduate admission consideration for Secondary School Record
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admTOEFL   string   
Admissions - Undergraduate admission consideration for TOEFL
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  admUseForBothSubmitted   string   
Admissions - If student submitted both SAT and ACT scores, and either can be considered for admission, use SAT test scores, ACT test scores or both?
Additional Notes
Valid values: A = ACT, S = SAT, B = Both; Default value (if no record or null value): B
  admUseForMultiOfSame   string   
Admissions - If student submitted two scores of the same test, use the highest score or an average of the scores?
Additional Notes
Valid values: H = Highest, A = Average; Default value (if no record or null value): H
  admUseTestScores   string   
Admissions - Use SAT test scores, ACT test scores or both for admission requirements?
Additional Notes
Valid values: A = ACT, S = SAT, B = Both; Default value (if no record or null value): B
  admWorkExperience   string   
Admissions - Undergraduate admission consideration for work experience
Additional Notes
Valid values: R = Required, C = Considered but not required, M = Recommended, N = Neither required nor recommended; Default value (if no record or null value): R
  compGradDateOrTerm   string   
Completions - Report awards based on graduation/awarded date or graduation/awarded term?
Additional Notes
Valid values: D = Date, T = Term; Default value (if no record or null value): D
  eviReserved1   string   
Reserved field for variable client info which may change year over year (null if not applicable)
Additional Notes
Used in 20-21 to store an institutions CARES Act fund code assignment for reporting of Financial Aid funding
  eviReserved2   string   
Reserved field for variable client info which may change year over year (null if not applicable)
Additional Notes
Used in 20-21 to store secondary CARES Act fund code assignment for reporting of Financial Aid funding
  eviReserved3   string   
Reserved field for variable client info which may change year over year (null if not applicable)
Additional Notes
Not applicable for 20-21
  eviReserved4   string   
Reserved field for variable client info which may change year over year (null if not applicable)
Additional Notes
Not applicable for 20-21
  eviReserved5   string   
Reserved field for variable client info which may change year over year (null if not applicable)
Additional Notes
Not applicable for 20-21
  feIncludeOptSurveyData   string   
Fall Enrollment - Include the optional data for the survey year?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): Y
  finAthleticExpenses   string   
Finance All - If your institution participates in intercollegiate athletics, how are the expenses accounted for?
Additional Notes
Valid values: A = Auxiliary Enterprises, S = Student Services, N = Does not participate, O = Other; Default value (if no record or null value): N
  finAthleticRevenue   string   
Finance All - If your institution participates in intercollegiate athletics, how is revenue accounted for?
Additional Notes
Valid values: A = Auxiliary Enterprises, E = Educational Activities, N = Does not participate, O = Other; Default value (if no record or null value): N
  finBusinessStructure   string   
Finance ForProfit - What type of business structure is the institution for tax purposes?
Additional Notes
Valid values: SP = Sole Proprietorship, P = Partnership, C = C Corp, SC = S Corp, LLC = LLC; Default value (if no record or null value): LLC
  finEndowmentAssets   string   
Finance All - Does this institution or any of its foundations or other affiliated organizations own endowment assets?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): Y
  finGPFSAuditOpinion   string   
Finance All - Did your institution receive an unqualified opinion on its General Purpose Financial Statements from your auditor?
Additional Notes
Valid values: Q = Qualified, UQ = Unqualified, U = Unknown/In Progress; Default value (if no record or null value): U
  finParentOrChildInstitution   string   
Finance Degree - If your institution reports on a parent/child basis, is this insititution consided a parent or child?
Additional Notes
Valid values: P = Parent, C = Child; Default value (if no record or null value): P
  finPellTransactions   string   
Finance FASB - Does your institution account for Pell grants as pass through transactions?
Additional Notes
Valid values: P = Pass through, F = Federal Grant Revenue, N = Does not award Pell grants; Default value (if no record or null value): P
  finPensionBenefits   string   
Finance All - Does your institution include defined benefit pension or OPEB liabilities, expenses, and/or deferrals in its GPFS?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): Y
  finReportingModel   string   
Finance GASB - Which GASB reporting model is used by your institution?
Additional Notes
Valid values: B = Business type, G = Government, GB = Government with Business; Default value (if no record or null value): B
  finTaxExpensePaid   string   
Finance NonDegree Private ForProfit - Who paid the reported tax expenses for your institution?
Additional Notes
Valid values: M = multi-institution or multi-campus organization indicated in IC Header, N = multi-institution or multi-campus organization NOT indicated in IC Header, I = reporting institution; Default value (if no record or null value): M
  fourYrOrLessInstitution   string   
Is the institution a 4-year or less-than-4-year institution?
Additional Notes
Valid values: FY = Four-year, LT = Less-than-four-year; Default value (if no record or null value): FY
  genderForNonBinary   string   
IPEDS allows for gender values of male and female. If a person has a gender with value is binary, report the gender as male or female?
Additional Notes
Valid values: M = Male, F = Female; Default value (if no record or null value): F
  genderForUnknown   string   
IPEDS allows for gender values of male and female. If a person has a gender with value unknown (or null), report the gender as male or female?
Additional Notes
Valid values: M = Male, F = Female; Default value (if no record or null value): M
  grReportTransferOut   string   
For Graduation Rates, should transfer out students be reported? Reporting is required for institutions offering programs with an intended transfer outcome but is otherwise optional.
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): N
  hrIncludeSecondarySalary   string   
Human Resources - Include secondary positions in the annual salary calculation?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): N
  icOfferDoctorAwardLevel   string   
InstitutionalCharacteristics - Do you offer post-graduate programs/awards - Doctors/Professional degrees?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): Y
  icOfferGraduateAwardLevel   string   
InstitutionalCharacteristics - Do you offer graduate programs/awards - Masters degrees?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): Y
  icOfferUndergradAwardLevel   string   
InstitutionalCharacteristics - Do you offer undergraduate programs/awards - Bachelors degrees and below?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): Y
  includeNonDegreeAsUG   string   
Include non-degree seeking students who take for-credit courses as UG?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): Y
  instructionalActivityType   string   
Does the institution measure instructional activity in credit hours, clock hours or both?
Additional Notes
Valid values: CR = Credit, CL = Clock, B = Both; Default value (if no record or null value): CR
  ncBranchCode   string   
National Clearinghouse Branch Code
Additional Notes
Valid values: last 2 digits of OPE Id; Default value (if no record or null value): 00
  ncSchoolCode   string   
National Clearinghouse School Code
Additional Notes
Valid values: first 6 digits of OPE Id; Default value (if no record or null value): 000000
  ncSchoolName   string   
National Clearinghouse proper school name
Additional Notes
Default value (if no record or null value): XXXXX
  publicOrPrivateInstitution   string   
Is the institution public or private?
Additional Notes
Valid values: U = Public, R = Private; Default value (if no record or null value): U
  recordActivityDate   date   
Date source record inserted or modified
  sfaGradStudentsOnly   string   
Financial Aid - Does the institution only enroll graduate students?
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): N
  sfaLargestProgCIPC   string   
Financial Aid - The institutions largest program, as reported in Institutional Characteristics. Program reporters ONLY
Additional Notes
CIPC (no dashes, just numeric characters); Default value (if no record): null
  sfaReportPriorYear   string   
Financial Aid - Report prior survey year data for parts D, E and F? Prior year data should only be reported if not previously reported to IPEDS.
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): N
  sfaReportSecondPriorYear   string   
Financial Aid - Report second prior survey year data for parts D, E and F? Second prior year data should only be reported if not previously reported to IPEDS.
Additional Notes
Valid values: Y = Yes, N = No; Default value (if no record or null value): N
  surveyCollectionYear   string    IPEDSReportingPeriod->surveyCollectionYear
The IPEDS collection survey year
Additional Notes
YYyy (1920 for 2019-2020)
  tmAnnualDPPCreditHoursFTE   number   
Twelve Month Enrollment - the number of credit hours in which a full-time Doctors Professional Practice student should be enrolled annually to be considered full-time
Additional Notes
Valid values: 1 to 99; Default value (if no record or null value): 12

Example SQL