LegacyLink Data Dictionary

Help

Description:
ADMISSIONS SYSTEM DATABASE
ADMISSIONS GROUP MASTERA TABLE DESCRIBING VARIOUS ADMISSIONS GROUPS.
Name
ADMISSIONS PROGRESS GROUP
Description
A CODE DEFINING ADMISSIONS PROGRESS GROUPS WITHIN THE RELATIONSHIP TABLES.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
SELECTION ELEMENT 1
Description
THIS FIELD WILL STORE A VALID DATA ELEMENT NAME, USED TO SELECT GROUPS OF STUDENTS WITH SPECIFIED VALUES.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
SELECTION RANGE 1
Description
THIS FIELD WILL STORE A BEGINNING RANGE VALUE RELATED TO SEL_ELMT_1
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SELECTION RANGE 2
Description
THIS FIELD WILL STORE AN ENDING RANGE VALUE RELATED TO SEL_ELMT_2.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SELECTION ELEMENT 2
Description
THIS FIELD WILL STORE A VALID DATA ELEMENT NAME, USED TO SELECT GROUPS OF STUDENTS WITH SPECIFIED VALUES.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
SELECTION RANGE 3
Description
THIS FIELD WILL STORE A BEGINNING RANGE VALUE RELATED TO SEL_ELMT_2.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SELECTION RANGE 4
Description
THIS FIELD WILL STORE AND ENDING RANGE VALUE RELATED TO SEL_ELMT_2.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
ADMISSIONS LAST ID MASTERA MASTER FILE CONTAINING THE LAST ASSIGNED TEMPORARY SID.
Name
COLLEGE CODE
Description
THE COLLEGE CODE; FIRST TWO DIGITS DESIGNATE DISTRICT, THIRD DESIGNATES COLLEGES WITHIN THE THE DISTRICT.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TEMPORARY STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER UNIQUELY IDENTIFYING A STUDENT.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
ADMISSIONS PROGRESS TABLEA TABLE DESCRIBING DIFFERENT LEVELS OF THE ADMISSIONS PROCESS.
Name
ADMISSIONS PROGRESS CODE
Description
A CODE DESCRIBING DIFFERENT LEVELS OF THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
COLLEGE DOCUMENT TABLEA TABLE DESCRIBING ANY CORRESPONDENCE THAT IS GENERATED THROUGH THE ADMISSIONS MODULE.
Name
COLLEGE DOCUMENT CODE
Description
THESE CODES DESCRIBE ANY CORRESPONDENCE THAT IS GENERATED THROUGH THE ADMISSIONS MODULE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
CONTACT ORIGIN TABLEA TABLE DESCRIBING WHERE THE ORIGINAL CONTACT WITH A STUDENT WAS MADE.
Name
CONTACT ORIGIN CODE
Description
THESE CODES DESCRIBE WHERE THE ORIGINAL CONTACT WITH A STUDENT WAS MADE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
OPTIONAL ADMISSIONS TABLE 1A FILE CONTAINING OPTIONAL ADMISSIONS DATA.
Name
OPTIONAL ADMISSIONS CODE 1
Description
A USER DEFINED FIELD DESCRIBING AN ADMISSIONS CODE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
OPTIONAL ADMISSIONS TABLE 2A FILE CONTAINING OPTIONAL ADMISSIONS DATA.
Name
OPTIONAL ADMISSIONS CODE 2
Description
A USER DEFINED FIELD DESCRIBING AND ADMISSIONS CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
OPTIONAL ADMISSIONS TABLE 3A FILE CONTAINING OPTIONAL ADMISSIONS DATA.
Name
OPTIONAL ADMISSIONS CODE 3
Description
A USER DEFINED FIELD DESCRIBING AN ADMISSIONS CODE,
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
STUDENT ACTIVITY TABLEA TABLE DESCRIBING DOCUMENTS OR ACTIVITIES THAT A STUDENT IS TO COMPLETE BEFORE CONTINUING IN THE ADMISSIONS PROCESS.
Name
STUDENT ACTIVITY CODE
Description
THESE CODES DESCRIBE DOCUMENTS OR ACTIVITIES THAT A STUDENT IS TO COMPLETE BEFORE CONTINUING IN THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
STUDENT INTEREST TABLEA TABLE DESCRIBING THE SPECIAL INTERESTS OR CONCERNS OF STUDENTS.
Name
STUDENT INTEREST CODE
Description
THESE CODES WILL DESCRIBE THE SPECIAL INTERESTS OR CONCERNS OF STUDENTS.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
PROGRESS/ ACTIVITY RELATIONSHIP TABLETHIS TABLE WILL BE USED TO ESTABLISH RELATIONSHIPS BETWEEN ADMISSION PROGRESS CODES AND VARIOUS STUDENT ACTIVITY CODES FOR A DESIRED YRQ.
Name
ADMISSIONS PROGRESS CODE
Description
A CODE DESCRIBING DIFFERENT LEVELS OF THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
ADMISSIONS PROGRESS GROUP
Description
A CODE DEFINING ADMISSIONS PROGRESS GROUPS WITHIN THE RELATIONSHIP TABLES.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
STUDENT ACTIVITY CODE
Description
THESE CODES DESCRIBE DOCUMENTS OR ACTIVITIES THAT A STUDENT IS TO COMPLETE BEFORE CONTINUING IN THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
REQUIREMENT IND
Description
THIS FIELD WILL DESIGNATE WHETHER ACTIVITIES ARE DESIRED OR REQUIRED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
RQ
=
REQUIRED
Name
ACTIVITY DUE DATE
Description
THE DATE AN ACTIVITY IS TO BE PERFORMED BY THE STUDENT.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ACTV_DUE_DATE
Description
SQL FORMATTED DATE FOR ACTV_DUE_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
YEAR/QUARTER
Description
A THREE-POSITION ACADEMIC YEAR (I.E., 1984-85= 845) FOLLOWED BY THE QUARTER CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
UNIQUE ADMISSIONS DOCUMENTS DETAILA FILE USED TO STORE ANY UNIQUE DOCUMENTS THAT ARE TO BE SENT TO A PARTICULAR STUDENT.
Name
SID/GROUP CODE
Description
SID/ADMISSIONS GROUP COMBINATION.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
COLLEGE DOCUMENT CODE
Description
THESE CODES DESCRIBE ANY CORRESPONDENCE THAT IS GENERATED THROUGH THE ADMISSIONS MODULE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
EXTRACT DATE
Description
THE DATE (MM/DD/YY) THAT THE EXTRACT WAS CREATED
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR EXTRACT_DATE
Description
SQL FORMATTED DATE FOR EXTRACT_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
ENTRY DATE
Description
DATE SID CHANGE REQUEST ENTERED VIA SUF SCREEN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ENTR_DATE
Description
SQL FORMATTED DATE FOR ENTR_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
ADMISSIONS CONTACT ORIGIN DETAILA FILE CONTAINING A STUDENT'S CONTACT ORIGIN CODES.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
CONTACT ORIGIN CODE
Description
THESE CODES DESCRIBE WHERE THE ORIGINAL CONTACT WITH A STUDENT WAS MADE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
ADMISSIONS STUDENT DOCUMENT DETAILA FILE USED TO TRACK DOCUMENTS THAT HAVE BEEN SENT TO A STUDENT.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
COLLEGE DOCUMENT CODE
Description
THESE CODES DESCRIBE ANY CORRESPONDENCE THAT IS GENERATED THROUGH THE ADMISSIONS MODULE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
EXTRACT DATE
Description
THE DATE (MM/DD/YY) THAT THE EXTRACT WAS CREATED
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR EXTRACT_DATE
Description
SQL FORMATTED DATE FOR EXTRACT_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
ENTRY DATE
Description
DATE SID CHANGE REQUEST ENTERED VIA SUF SCREEN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ENTR_DATE
Description
SQL FORMATTED DATE FOR ENTR_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
ADMISSION ELEMENT DETAILMISCELLANEOUS USER-DEFINED FIELDS FOR ADMISSION INFORMATION MODULE.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
ELEMENT CODE
Description
THE COMBINATION OF DATA ELEMENT NAME AND A CODE ASSOCIATED WITH THE DATA ELEMENT.
Type
NVARCHAR(24)
Variable length string of up to 24 characters.
ADMISSIONS STUDENT HISTORY DETAILA FILE USED TO TRACK A STUDENT'S PROGRESS THROUGH THE ADMISSIONS SYSTEM.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
ADMISSIONS PROGRESS CODE
Description
A CODE DESCRIBING DIFFERENT LEVELS OF THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
ADMISSIONS PROGRESS GROUP
Description
A CODE DEFINING ADMISSIONS PROGRESS GROUPS WITHIN THE RELATIONSHIP TABLES.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
ENTRY DATE
Description
DATE SID CHANGE REQUEST ENTERED VIA SUF SCREEN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ENTR_DATE
Description
SQL FORMATTED DATE FOR ENTR_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
ADMISSIONS STUDENT INTEREST DETAILA FILE CONTAINING A STUDENT'S INTEREST CODES.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
STUDENT INTEREST CODE
Description
THESE CODES WILL DESCRIBE THE SPECIAL INTERESTS OR CONCERNS OF STUDENTS.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
ADMISSIONS REQUIREMENTS DETAILA FILE USED TO STORE ANY UNIQUE REQUIREMENTS FOR A PARTICULAR STUDENT.
Name
SID/GROUP CODE
Description
SID/ADMISSIONS GROUP COMBINATION.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
STUDENT ACTIVITY CODE
Description
THESE CODES DESCRIBE DOCUMENTS OR ACTIVITIES THAT A STUDENT IS TO COMPLETE BEFORE CONTINUING IN THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
REQUIREMENT IND
Description
THIS FIELD WILL DESIGNATE WHETHER ACTIVITIES ARE DESIRED OR REQUIRED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
BLANK
=
DESIRED
Name
ACTIVITY DUE DATE
Description
THE DATE AN ACTIVITY IS TO BE PERFORMED BY THE STUDENT.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ACTV_DUE_DATE
Description
SQL FORMATTED DATE FOR ACTV_DUE_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
ENTRY DATE
Description
DATE SID CHANGE REQUEST ENTERED VIA SUF SCREEN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ENTR_DATE
Description
SQL FORMATTED DATE FOR ENTR_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
ADMISSIONS STUDENT ACTIVITY DETAILA FILE USED TO TRACK ACTIVITIES THAT HAVE BEEN PERFORMED BY THE STUDENT, TO COMPLETE THE ADMISSIONS PROCESS.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
STUDENT ACTIVITY CODE
Description
THESE CODES DESCRIBE DOCUMENTS OR ACTIVITIES THAT A STUDENT IS TO COMPLETE BEFORE CONTINUING IN THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
REQUIREMENT IND
Description
THIS FIELD WILL DESIGNATE WHETHER ACTIVITIES ARE DESIRED OR REQUIRED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
BLANK
=
DESIRED
Name
ACTIVITY DUE DATE
Description
THE DATE AN ACTIVITY IS TO BE PERFORMED BY THE STUDENT.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ACTV_DUE_DATE
Description
SQL FORMATTED DATE FOR ACTV_DUE_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
ENTRY DATE
Description
DATE SID CHANGE REQUEST ENTERED VIA SUF SCREEN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ENTR_DATE
Description
SQL FORMATTED DATE FOR ENTR_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
ADMISSIONS STUDENT DETAILA FILE CONTAINING STUDENT DEMOGRAPHIC DATA.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
ADMISSIONS PROGRESS CODE
Description
A CODE DESCRIBING DIFFERENT LEVELS OF THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
STUDENT'S FIRST NAME
Description
THE STUDENT'S FIRST NAME.
Type
NVARCHAR(12)
Variable length string of up to 12 characters.
Name
STUDENT'S LAST NAME
Description
THE STUDENT'S LAST NAME.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
STUDENT'S MIDDLE INITIAL
Description
STUDENT'S NAME: MIDDLE INITIAL.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
MAILING ADDRESS: STREET
Description
THE STUDENT'S MAILING ADDRESS: STREET.
Type
NVARCHAR(24)
Variable length string of up to 24 characters.
Name
MAILING ADDRESS: CITY
Description
THE STUDENT'S MAILING ADDRESS: CITY.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
MAILING ADDRESS: STATE
Description
THE STUDENT'S MAILING ADDRESS: STATE
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
MAILING ADDRESS: ZIP CODE
Description
THE STUDENT'S MAILING ADDRESS: ZIP CODE.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
STUDENT'S DAY PHONE NUMBER
Description
THE STUDENT'S DAYTIME PHONE NUMBER. THE FIRST THREE POSITIONS ARE THE AREA CODE.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
STUDENT'S EVENING PHONE NUMBER
Description
THE STUDENT'S EVENING PHONE NUMBER. THE FIRST THREE POSITIONS ARE THE AREA CODE.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
SEX
Description
IDENTIFIES A STUDENT'S SEX.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
F
=
FEMALE
BLANK
=
UNKNOWN
Name
BRANCH
Description
OPTIONAL CODE ASSIGNED BY THE USER TO IDENTIFY COLLEGE BRANCH SITE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
YEAR/QUARTER THE STUDENT PLANS TO START
Description
IDENTIFIES THE YEAR AND QUARTER THE STUDENT PLANS TO BEGIN ATTENDING CLASSES.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Values
2
=
FALL
3
=
WINTER
4
=
SPRING
5
=
SUMMER AND FALL
Name
STUDENT'S PROGRAM APPLIED FOR
Description
ACCOMMODATES THE CODE DESCRIBING THE PROGRAM THAT THE STUDENT APPLIED FOR.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TIME PREFERENCE
Description
INDICATES A STUDENT'S PREFERENCE FOR CLASS ATTENDANCE. BLANK = NO PREFERENCE 1 = DAYS 2 = EVENINGS 3 = DAYS AND EVENINGS
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
ADMISSION NUMBER
Description
THE NUMBER ASSIGNED TO EACH STUDENT DETERMINING ADMISSIONS SEQUENCE.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
DATE OF RECIEPT OF APPLICATION FORM
Description
THE DATE OF RECEIPT OF THE APPLICATION FORM.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR APP_RCPT_DATE
Description
SQL FORMATTED DATE FOR APP_RCPT_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
ADVISOR IDENTIFICATION CODE
Description
A CODE IDENTIFYING THE ADVISOR. CODES ARE ASSIGNED AND DEFINED BY THE USER.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
DATE OF BIRTH
Description
THE DATE ON WHICH THE INDIVIDUAL(STUDENT, EMPLOYEE, FINANCIAL AID APPLICANT) WAS BORN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR BIRTH_DATE
Description
SQL FORMATTED DATE FOR BIRTH_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
BAD ADDRESS CODE
Description
A TWO CHARACTER CODE TO INDICATE WHY AN ADDRESS IS TERMED UNDELIVERABLE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
ETHNIC ORIGIN
Description
CODE THAT IDENTIFIES THE STUDENT'S ETHNIC BACKGROUND.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
2
=
BLACK, NOT OF HISPANIC ORIGIN
3
=
AMERICAN INDIAN OR ALASKA NATIVE
4
=
HISPANIC
6
=
WHITE
Name
RESIDENCY STATUS
Description
REPRESENTS THE RESIDENCY CLASSIFICATION OF THE STUDENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
02
=
NON-RESIDENT
03
=
UNDETERMINED
Name
STUDENT'S FEE PAYING STATUS
Description
A CODE DESCRIBING THE FEE-PAYING STATUS OF THE STUDENT FOR EACH OF HIS CLASSES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
VALID CODES.
Name
VETERAN BENEFIT
Description
INDICATES THE STUDENT'S VETERAN STATUS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
2
=
VETERAN RECEIVING BENEFITS; NOT SEA
3
=
SEA VETERAN NOT RECEIVING BENEFITS
4
=
VETERAN NOT RECEIVING BENEFITS; NOT SEA
5
=
DEPENDENT OF VETERAN; RECEIVING BENEFITS
0
=
NOT A VETERAN
Name
HIGH SCHOOL ATTENDED
Description
DESIGNATES THE HIGH SCHOOL LAST ATTENDED BY THE STUDENT.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CITIZENSHIP STATUS
Description
IDENTIFIES THE CITIZENSHIP STATUS OF THE SPECIFIC STUDENT OR THE TYPE OF VISA UNDER WHICH A STUDENT IS ATTENDING COLLEGE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
VALID CODES.
Name
LAST YEAR ATTENDED HIGH SCHOOL
Description
THE LAST TWO DIGITS OF THE LAST YEAR THAT THE STUDENT ATTENDED HIGH SCHOOL.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
GRADUATED FROM HIGH SCHOOL
Description
INDICATES IF THE STUDENT GRADUATED FROM HIGH SCHOOL.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO
BLANK
=
UNKNOWN, NOT APPLICABLE
Name
HIGH SCHOOL TRANSCRIPT
Description
INDICATES IF THE HIGH SCHOOL TRANSCRIPT WAS RECEIVED. CODING Y = YES N = NO BLANK = NO
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
PREVIOUS COLLEGE 1
Description
DESIGNATES PREVIOUS COLLEGE ATTENDED. USE A THREE DIGIT CODE FOLLOWED BY ONE SPACE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
YEAR ATTENDED PREVIOUS COLLEGE 1
Description
THE LAST TWO DIGITS OF LAST YEAR ATTENDED AT PREVIOUS COLLEGE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
GRADUATED FROM PREVIOUS COLLEGE 1
Description
INDICATES IF THE STUDENT GRADUATED FROM THE PREVIOUS COLLEGE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO
BLANK
=
NO
Name
TRANSCRIPT RECEIVED FROM PREVIOUS COLLEGE 1
Description
INDICATES IF THE STUDENT'S TRANSCRIPT WAS RECEIVED FROM THE PREVIOUS COLLEGE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO
BLANK
=
NO
Name
PREVIOUS COLLEGE 2
Description
DESIGNATES PREVIOUS COLLEGE ATTENDED. USE A THREE-DIGIT CODE FOLLOWED BY ONE SPACE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
YEAR ATTENDED PREVIOUS COLLEGE 2
Description
THE LAST TWO DIGITS OF LAST YEAR ATTENDED AT PREVIOUS COLLEGE 2.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
GRADUATED FROM PREVIOUS COLLEGE 2
Description
INDICATES IF THE STUDENT GRADUATED FROM THE PREVIOUS COLLEGE
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
Y
=
YES
N
=
NO
Name
TRANSCRIPT RECEIVED FROM PREVIOUS COLLEGE 2
Description
INDICATES IF THE STUDENT'S TRANSCRIPT WAS RECEIVED FROM THE PREVIOUS COLLEGE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
BLANK
=
NO
Y
=
YES
Name
TRANSFERRED_IN COLLEGE CREDITS
Description
THE NUMBER OF CREDITS TRANSFERRED-IN FROM OTHER COLLEGES.
Type
NUMERIC(5,1)
Number of length 5 including 1 positions after the decimal.
Name
STUDENT TYPE
Description
IDENTIFIES THE STUDENT'S CLASSIFICATION. CODES ARE ASSIGNED AND DEFINED BY THE USER.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
REGISTRATION DEPOSIT
Description
INDICATES IF STUDENT HAS MADE A REGISTRATION DEPOSIT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO
BLANK
=
NO
Name
BACHELOR OF ARTS DEGREE
Description
INDICATES IF THE STUDENT HAS GRADUATED PREVIOUSLY WITH A BATCHELOR OF ARTS DEGREE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
Y
=
YES
N
=
NO
Name
RECORDS FEE
Description
INDICATES IF THE STUDENT HAS PAID THE RECORDS FEE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
BLANK
=
UNKNOWN, NOT APPLICABLE
N
=
NO
Name
STUDENT ENROLLMENT STATUS
Description
CLASSIFIES THE ENROLLMENT STATUS OF THE STUDENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
2
=
REAPPLICANT
3
=
FORMER
4
=
RETURNING (ENROLLED PREVIOUS QUARTER)
9
=
TRANSFER STUDENT
Name
HEALTH LIMITATIONS
Description
ACCOMMODATES UP TO FOUR CODES DESCRIBING HEALTH LIMITATIONS OF THE STUDENT. BLANK = NO LIMITATIONS 0 = TUBERCULOSIS 1 = SEVERE VISION LOSS 2 = HEARING LOSS 3 = ARTIFICIAL LIMB 4 = WHEEL CHAIR 5 = DIABETES 6 = HEART AILMENT 7 = RESPIRATORY AILMENT 8 = EPILEPSY CONVULSIONS 9 = HIGH BLOOD PRESSURE NEW CODING EFFICTIVE 5/97 BLANK = NO LIMITATIONS 1 = DEAF/HEARING 2 = MOBILITY 3 = SPEECH/LANGUAGE 4 = LEARNING DISABILITY 5 = BLIND/VISUAL 6 = CHRONIC/ACUTE HEALTH 7 = NEUROLOGICAL/NERVOUS SYSTEM 8 = PSYCHOLOGICAL/EMOTIONAL
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
OPTIONAL ADMISSIONS CODE 1
Description
A USER DEFINED FIELD DESCRIBING AN ADMISSIONS CODE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
OPTIONAL ADMISSIONS CODE 2
Description
A USER DEFINED FIELD DESCRIBING AND ADMISSIONS CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
OPTIONAL ADMISSIONS CODE 3
Description
A USER DEFINED FIELD DESCRIBING AN ADMISSIONS CODE,
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
CENSUS RACE GROUP CODE
Description
A CLASSIFICATION OF RACE/ETHNIC CATEGORIES WHICH ADHERES TO THE DATA CLASSIFICATIONS AS COLLECTED BY THE U.S. CENSUS QUESTIONNAIRE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CENSUS HISPANIC/SPANISH CODE
Description
A CLASSIFICATION OF HISPANIC/SPANISH ORIGINS WHICH ADHERES TO THE DATA CLASSIFICATIONS AS COLLECTED BY THE U.S. CENSUS QUESTIONNAIRE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
YEAR/QUARTER
Description
A THREE-POSITION ACADEMIC YEAR (I.E., 1984-85= 845) FOLLOWED BY THE QUARTER CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
ENTRY DATE
Description
DATE SID CHANGE REQUEST ENTERED VIA SUF SCREEN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ENTR_DATE
Description
SQL FORMATTED DATE FOR ENTR_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
PREVIOUS NAME
Description
ACCOMMODATES A PREVIOUSLY USED NAME.
Type
NVARCHAR(12)
Variable length string of up to 12 characters.
Name
PREVIOUS NAME 2
Description
ACCOMMODATES A SECOND PREVIOUSLY USED NAME.
Type
NVARCHAR(12)
Variable length string of up to 12 characters.
Name
ADMISSIONS STATUS
Description
IDENTIFIES THE STATUS OF THE STUDENT IN THE EDUCATIONAL PROGRAM APPLIED FOR.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
3
=
STUDENT IS ON A WAITING LIST FOR THE EDUCATIONAL PROGRAM APPLIED FOR
1
=
STUDENT ACCEPTED IN EDUCATIONAL PROGRAM APPLIED FOR
Name
STUDENT EMAIL ADDRESS
Description
E-MAIL ADDRESS OF STUDENT USED PRIMARILY FOR WEB ADMISSIONS
Type
NVARCHAR(60)
Variable length string of up to 60 characters.
Name
SOCIAL SECURITY NUMBER
Description
A STUDENT'SSOCIAL SECURITY NUMBER.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
CENSUS RACE CODE 2
Description
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
ADMISSIONS STUDENT GROUP DETAILA FILE CONTAINING A STUDENT'S CURRENT ADMISSIONS GROUPS.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
ADMISSIONS PROGRESS GROUP
Description
A CODE DEFINING ADMISSIONS PROGRESS GROUPS WITHIN THE RELATIONSHIP TABLES.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
ENTRY DATE
Description
DATE SID CHANGE REQUEST ENTERED VIA SUF SCREEN.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR ENTR_DATE
Description
SQL FORMATTED DATE FOR ENTR_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
ADMISSIONS CROSS REFERENCE ID FILEA DETAIL DATA SET CONTAINING A CROSS REFERENCE OF SID'S.
Name
STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER ELEMENT UNIQUELY IDENTIFYING A STUDENT/EMPLOYEE.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
TEMPORARY STUDENT IDENTIFICATION NUMBER
Description
A NINE CHARACTER UNIQUELY IDENTIFYING A STUDENT.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
ABBREVIATED LAST NAME
Description
THE FIRST FIVE CHARACTERS FROM THE STUDENT NAME FIELD.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SOUNDEX LAST NAME
Description
A SOUNDEX CODE FOR AN INDIVIDUAL'S LAST NAME.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
PROGRESS/ DOCUMENT RELATIONSHIP TABLETHIS TABLE WILL BE USED TO ESTABLISH RELATIONSHIPS BETWEEN ADMISSION PROGRESS CODES AND VARIOUS DOCUMENT TRACKING CODES FOR A DESIRED YQR.
Name
ADMISSIONS PROGRESS CODE
Description
A CODE DESCRIBING DIFFERENT LEVELS OF THE ADMISSIONS PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
ADMISSIONS PROGRESS GROUP
Description
A CODE DEFINING ADMISSIONS PROGRESS GROUPS WITHIN THE RELATIONSHIP TABLES.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
COLLEGE DOCUMENT CODE
Description
THESE CODES DESCRIBE ANY CORRESPONDENCE THAT IS GENERATED THROUGH THE ADMISSIONS MODULE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
EXTRACT DATE
Description
THE DATE (MM/DD/YY) THAT THE EXTRACT WAS CREATED
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR EXTRACT_DATE
Description
SQL FORMATTED DATE FOR EXTRACT_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
YEAR/QUARTER
Description
A THREE-POSITION ACADEMIC YEAR (I.E., 1984-85= 845) FOLLOWED BY THE QUARTER CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
DOWNLOAD FILE TEMPLATEA FILE CONTAINING A DESCRIPTION OF DATA ELEMENTS TO BE INCLUDED IN AN EXTRACT FILE.
Name
DOWNLOAD FILE TEMPLATE NAME
Description
A KEY FIELD TO INDENTIFY DOWNLOAD FILE TEMPLATES.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
TITLE _ 30 CHARACTERS
Description
TITLE USED FOR REPORT DESCRIPTION AND TITLING.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
SELECTION ELEMENT 1
Description
THIS FIELD WILL STORE A VALID DATA ELEMENT NAME, USED TO SELECT GROUPS OF STUDENTS WITH SPECIFIED VALUES.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Description:
AFRS DATA BASE
AFRS APPROPRIATION INDEX
Name
AFRS APPROPRIATION INDEX KEY
Description
THE CONCATENATION OF AFRS_APPR_INDX AND BIEN TO FORM THE KEY TO THE AFRS_APPR_INDX_M.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
TITLE
Description
A DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTITY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
AFRS APPROPRIATION
Description
THE APPROPRIATION THAT WILL BE REPORTED TO AFRS FOR AN INTERNALLY-USED APPROPRIATION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
APPROPRIATION TYPE
Description
A ONE CHARACTER CODE TO IDENTIFY THE TYPE OF APPROPRIATION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
2
=
FEDERAL
3
=
FEDERAL UNANTICIPATED
4
=
GOVERNOR'S EMERGENCY ALLOCATIONS
6
=
NON-APPROPRIATED FUNDS
7
=
PRIVATE/LOCAL
8
=
STATE - UNANTICIPATED
9
=
PRIVATE/LOCAL-UNANTICIPATED
Name
APPROPRIATION CHARACTER
Description
A ONE CHARACTER CODE TO IDENTIFY OPERATING AND CAPITAL APPROPRIATIONS FOR REPORTING PURPOSES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
2
=
CAPITAL
Name
AFRS FUND
Description
A THREE CHARACTER CODE REPORTED TO AFRS FOR A PARTICULAR FUND.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
AFRS FUND DETAIL
Description
A TWO CHARACTER CODE IDENTIFYING A FURTHER CLASSIFICATION OF THE ACCOUNTING FUND ENTITIES, AS DEFINED BY OFM.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
AFRS OBJECT
Description
THE OBJECT THAT WILL BE REPORTED TO AFRS FOR AN INTERNALLY-USED OBJECT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
APPROPRIATION START DATE
Description
THE DATE ON WHICH THE APPROPRIATION FOR A GIVEN BIENNIUM BEGINS.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR APPR_STRT_DATE
Description
SQL FORMATTED DATE FOR APPR_STRT_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
APPROPRIATION END DATE
Description
THE DATE ON WHICH THE APPROPRIATION FOR A GIVEN BIENNIUM ENDS.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR APPR_END_DATE
Description
SQL FORMATTED DATE FOR APPR_END_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
APPROPRIATION CONTROL TYPE INDICATOR
Description
A CODE ASSIGNED TO IDENTIFY THE TYPE OF CONTROL EXERCISED ON FINANCIAL TRANSACTIONS IN THE AGENCY FINANCIAL REPORTING SYSTEM (AFRS).
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
ABSOLUTE APPROPRIATION FUND CONTROL
2
=
ADVISORY APPROPRIATION FUND CONTROL
Name
APPROPRIATION/ORGANIZATION LEVEL INDICATOR
Description
THE APPROPRIATION ORGANIZATION LEVEL INDICATOR INDICATES ORGANIZATION LEVEL AT WHICH THE APPROPRIATION IS TO BE CONTROLLED, IN THE AFRS SYSTEM.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
CONTROL APPROPRIATIONS AT THE AGENCY LEVEL AND DIVISION LEVEL.
Name
APPROPRIATION/PROGRAM LEVEL INDICATOR
Description
THE APPROPRIATION PROGRAM LEVEL INDICATOR IDENTIFIES THE LEVEL OF APPROPRIATION CONTROL WITHIN THE PROGRAM HIERARCHY, IN THE AFRS SYSTEM
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
FUNCTION LEVEL
2
=
PROGRAM LEVEL
3
=
SUBPROGRAM LEVEL
Name
APPROPRIATION OBJECT LEVEL INDICATOR
Description
THE APPROPRIATION OBJECT LEVEL INDICTOR IDENTIFIES THE LEVEL OF OBJECT CONTROL FOR THE APPROPRIATION, IN THE AFRS SYSTEM.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
OBJECT LEVEL CONTROL
Name
CASH CONTROL TYPE INDICATOR
Description
THE CASH CONTROL TYPE INDICATOR IDENTIFIES THE LEVEL OF CASH IN THE AFRS SYSTEM.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
ABSOLUTE CASH CONTROL
2
=
ADVISORY CASH CONTROL
Name
ALLOTMENT OBJECT LEVEL INDICATOR
Description
A CODE TO IDENTIFY THE LEVEL OF OBJECT CONTROL FOR ALLOTMENTS IN THE AGENCY FINANCIAL REPORTING SYSTEM (AFRS).
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
ALLOTMENT BY OBJECT
2
=
ALLOTMENT BY SUBOBJECT
3
=
ALLOTMENT BY SUB-SUBOBJECT
Name
REVERSION INDICATOR
Description
A CODE REQUIRED FOR REPORTING TO AGENCY FINANCIAL REPORTING SYSTEM(AFRS) INDICATING WHETHER REVERSION APPLIES TO AN APPROPRIATION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
EDIT STATUS
Description
A CODE INDICATING THE EDITING STATUS OF A PARTICULAR CODE OR COMBINATION OF CODES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
I
=
INACTIVE
D
=
DELETE
A
=
ACTIVE
L
=
LIMITED
Name
AFRS UPDATE INDICATOR
Description
A CODE INDICATING THE ACTION TO BE TAKEN WITH A TABLE ENTRY.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
C
=
CHANGE
D
=
DELETE
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
AFRS APPROPRIATION TABLE
Name
AFRS APPROPRIATION
Description
THE APPROPRIATION THAT WILL BE REPORTED TO AFRS FOR AN INTERNALLY-USED APPROPRIATION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE
Description
A DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTITY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
EDIT STATUS
Description
A CODE INDICATING THE EDITING STATUS OF A PARTICULAR CODE OR COMBINATION OF CODES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
A
=
ACTIVE
N
=
NON-ACCOUNTING
D
=
DELETE
I
=
INACTIVE
Name
AFRS UPDATE INDICATOR
Description
A CODE INDICATING THE ACTION TO BE TAKEN WITH A TABLE ENTRY.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
A
=
ADD
D
=
DELETE
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
AFRS ORGANIZATION CONTROL TABLE
Name
BIENNIUM
Description
A 24 MONTH PERIOD EXTENDING FROM JULY 1 OF ODD NUMBERED YEARS TO JUNE 30 OF ODD NUMBER YEARS TO WHICH AN OPERATING BUDGET APPLIES.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
ORGANIZATION INDEX
Description
A CODE USED TO REPRESENT A UNIQUE COMBINATION OF CAMPUS, DIVISION, DEPARTMENT, COST CENTER PROJECT NUMBER, SUBPROJECT, PROJECT PHASE, GRANT/CONTRACT NUMBER, COUNTY AND CITY/TOWN.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
AFRS PROGRAM INDEX
Description
THE PROGRAM INDEX THAT WILL BE REPORTED TO AFRS FOR AN ACCOUNTING PROGRAM INDEX.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
AFRS SUBOBJECT
Description
THE SUBOBJECT THAT IS REPORTED TO AFRS FOR AN INTERNALLY USED SOBJ.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
AFRS SOURCE OF REVENUE
Description
THE SOURCE OF REVENUE (MAJOR GROUP/MAJOR SOURCE) THAT IS REPORTED TO AFRS FOR AN INTERNALLY USED SRC_REV.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
AFRS FUND
Description
A THREE CHARACTER CODE REPORTED TO AFRS FOR A PARTICULAR FUND.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
AFRS FUND DETAIL
Description
A TWO CHARACTER CODE IDENTIFYING A FURTHER CLASSIFICATION OF THE ACCOUNTING FUND ENTITIES, AS DEFINED BY OFM.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
AFRS MONTHLY POSTING INDICATOR
Description
THIS FIELD CONTAINS THE ONE POSITION CODE THAT IDENTIFIES IF THE PRIOR FISCAL MONTH IS OPEN FOR POSTING.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
PRIOR MONTH CLOSED FOR POSTING
T
=
PRIOR MONTH TEMPORARILY CLOSED FOR POSTING
Name
AFRS BIENNIUM POSTING INDICATOR
Description
THIS FIELD CONTAINS THE ONE POSITION CODE THAT IDENTIFIES IF THE PRIOR BIENNIUM IS OPEN FOR POSTING.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
PRIOR BIENNIUM CLOSED FOR POSTING
Name
LEAP MONTHLY POSTING INDICATOR
Description
THIS FIELD CONTAINS THE ONE POSITION CODE THAT IDENTIFIES IF THE PRIOR MONTH'S DATA IS CLOSED AND READY FOR INTERFACING TO LEAP.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
MONTHLY INPUT NOT READY FOR TRANSMISSION
Name
LEAP BIENNIUM POSTING INDICATOR
Description
THIS FIELD CONTAINS THE ONE POSITION CODE THAT IDENTIFIES IF THE PRIOR BIENNIUM DATA IS CLOSED AND READY FOR INTERFACING TO LEAP.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
BIENNIUM DATA NOT READY FOR TRANSMISSION
Name
AFRS STATEWIDE DECISION TABLE
Description
THIS FIELD INDICATES WHETHER OR NOT THE ORGANIZATION USES THE STANDARD STATEWIDE DECISION TABLE. THIS FIELD MUST BE CODED WITH A "Y".
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
DATA SEVERITY INDICATOR A
Description
THE FIRST SET OF 40, ONE CHARACTER CODES INDICATING THE SEVERITY OF DATA RELATED ERRORS.
Type
NVARCHAR(40)
Variable length string of up to 40 characters.
Values
E10
=
WORKCLASS NOT IN D40 2 W, F
E13
=
SUB SUBOBJECT NOT IN D12 3 W, F
E14
=
CITIES/TOWNS NOT IN D38 4 W, F
E16
=
SOURCE NOT IN D35 5 W, F
E38
=
ORG INDX REQUIRED 6 D, W, F
E45
=
ORG INDX NOT ALLOWED 7 W, F
E46
=
OPT ORG INDX NOT IN IC 8 D, W, F
E47
=
ORG INDX REQR 9 D, W, F
E48
=
REQR ORG INDX NOT IN IC 10 D, W, F
E58
=
FUND DETAIL NOT ALLOWED 11 W, F
E59
=
OPT FUND DETAIL NOT IN D23 12 W, F
E60
=
FUND DETAIL IS REQUIRED 13 W, F
E61
=
REQR FND DETAIL NOT IN D23 14 W, F
E63
=
OPT PRG_INDX NOT IN PI 15 D, F
E64
=
PROGRAM INDEX IS REQUIRED 16 D, F
E65
=
REQR PRG INDX NOT IN PI 17 D, F
E67
=
OPT SUBOBJECT NOT IN D11 18 D, W, F
E68
=
SUBOBJECT IS REQUIRED 19 D, F
E69
=
REQR SUBOBJECT NO IN D11 20 D, F
E71
=
OPT SOURCE NOT IN D35 21 D, W, F
E72
=
SOURCE IS REQUIRED 22 D, F
E73
=
REQR SOURCE NOT IN D35 23 D, F
E75
=
OPT PROJECT NOT IN PC 24 W, F
E76
=
PROJECT IS REQUIRED 25 W, F
E77
=
REQR PROJECT NOT IN PC 26 W, F
E78
=
VNDR NUM NOT ALLOWED 27 W, F
E79
=
OPT VNDR NUM NOT IN VE 28 W, F
E81
=
REQR VNDR NUM NOT IN VE 29 W, F
E91
=
INV NUM IS REQUIRED 30 W, F
EJ1
=
APPR OBJ REQR SUBOBJECT 31 D
EJ2
=
ALLOT OBJ REQR SUBOBJECT 32 D
Name
DATA SEVERITY INDICATORS B
Description
THE SECOND SET OF 40 ONE CHARACTER CODES INDICATING THE SEVERITY OF DATA RELATED ERRORS.
Type
NVARCHAR(40)
Variable length string of up to 40 characters.
Values
F
=
FATAL
D
=
DEFAULT
BLANK
=
DEFUALTS TO SYSTEM EDIT.
Name
FUND SEVERITY INDICATORS A
Description
THE FIRST SET OF 40, ONE CHARACTER CODES INDICATING THE SEVERITY OF FUND RELATED ERRORS. F01 OVERLIQUIDATION OF ENCUMBRANCE-CURRENT MONTH POSITION = 1; VALID VALUES = F F02 OVERLIQUIDATION OF ENCUMBRANCE - PRIOR MONTH POSITION = 2; VALID VALUES = F F03 OVERLIQUIDATION OF ENCUMBRANCE - PRIOR YEAR POSITION = 3; VALID VALUES = F F04 ATTEMPTED POSTING TO CLOSED DOCUMENT POSITION = 4; VALID VALUES = W, F F05 REVERSE ATTEMPTED W/PARTIAL OR FULL LIQUID. POSITION = 5; VALID VALUES = F F06 NO MATCH WHEN POSTING TO DOC FILE ADJ AMOUNT POSITION = 6; VALID VALUES = F F11 APPROP OVEREXP OR OVEROBLIGATED-CURRENT MONTH POSITION = 11; VALID VALUES = W, F F12 APPROP OVEREXP OR OVERCOMMITTED - PRIOR MONTH POSITION = 12; VALID VALUES = W, F F13 APPROP OVEREXP OR OVERCOMMITTED - PRIOR MONTH POSITION = 13; VALID VALUES = W, F F14 ALLOTMENT OVEREXPEND - CURRENT POSITION = 14, VALID VALUES = W, F F15 ALLOTMENT OVEREXPEND, PRIOR MONTH POSITION = 15, VALID VALUES = W, F F16 ALLOTMENT OVEREXPEND - PRIOR YEAR POSITION = 16, VALID VALUES = W, F F17 EXPENDITURES EXCEED APPROPRIATIONS - CURR MO POSITION = 17, VALID VALUES = W, F F18 EXPENDITURES EXCEED APPROPRIATIONS - PRIOR MO POSITION = 18, VALID VALUES = W, F F19 EXPENDITURES EXCEED APPROPRIATIONS - PRIOR YR POSITION = 19, VALID VALUES = W, F F20 TRANSACTION NOT WITHIN APPR START & END DATES POSITION = 20; VALID VALUES = F F30 EXPEND EXCEED ALLOT & REVERSIONS - CURR MONTH POSITION = 30; VALID VALUES = W, F F31 EXPEND EXCEED ALLOT & REVERSION - PRIOR MONTH POSITION = 31; VALID VALUES = W, F F32 EXPEND EXCEED ALLOT & REVERSIONS-PRIOR MONTH POSITION = 32; VALID VALUES = W, F F33 EXPENDITURES EXCEED ALLOTMENTS - CURR MONTH POSITION = 33; VALID VALUES = W, F F34 EXPENDITURES EXCEED ALLOTMENTS - PRIOR MONTH POSITION = 34; VALID VALUES = W, F F35 EXPENDITURES EXCEED ALLOTMENTS - PRIOR MONTH POSITION = 35; VALID VALUES = W, F F36 POSTING ATTEMPTED TO CLOSED ALLOTMENT POSITION = 36; VALID VALUES = F F40 ATTEMPTED CREATION OF NEG CASH BAL-CURR MONTH POSITION = 40; VALID VALUES = W, F
Type
NVARCHAR(40)
Variable length string of up to 40 characters.
Values
F
=
FATAL
BLANK
=
FATAL
Name
FUND SEVERITY INDICATORS B
Description
THE SECOND SET OF 40, ONE CHARACTER CODES INDICATING THE SEVERITY OF FUND RELATED ERRORS. F41 ATTEMPTED CREATION OF NEG CASH BAL-PRIOR MO POSITION = 41; VALID VALUES = W, F F42 ATTEMPTED CREATION OF NEG CASH BAL-PRIOR YEAR POSITION = 42; VALID VALUES = W, F F50 GRANT/PROJ FILE BUDGET OVER-REVERSED-CURR MO POSITION = 50; VALID VALUES = W, F F51 GRANT/PROJ FILE BUDGET OVER-REVERSED-PRIOR MO POSITION = 51; VALID VALUES = W, F F52 GRANT/PROJ FILE BUDGET OVER-REVERSED-PRIOR YR POSITION = 52; VALID VALUES = W, F F53 GRANT/PROJ FILE BUDGET OVEREXPENDED-CURR MO POSITION = 53; VALID VALUES = W, F F54 GRANT/PROJ FILE BUDGET OVEREXPENDED-PRIOR MO POSITION = 54; VALID VALUES = W, F F55 GRANT/PROJ FILE BUDGET OVEREXPENDED-PRIOR YR POSITION = 55; VALID VALUES = W, F F57 TRANS NOT WITHIN GRANT/PROJ START & END DATES POSITION = 57; VALID VALUES = W, F F71 NO MATCH FOR POSTING TO DOCUMENT FILE POSITION = 71; VALID VALUES = F F72 ATTEMPT TO ESP DOCUMENT IN DOC FILE POSITION = 72; VALID VALUES = F F73 APPROP USED WAS NOT FOUND ON APPROP FILE POSITION = 73; VALID VALUES = F F74 ATTEMPT TO ESTABLISH DUP APPRO IN APPRO FILE POSITION = 74; VALID VALUES = F F75 ALLOTMENT USED WAS NOT FOUND ON ALLOT FILE POSITION = 75; VALID VALUES = F F76 ATTEMPT TO ESTABLISH DUP ALLOT ON ALLOT FILE POSITION = 76; VALID VALUES = F F77 NO MATCH FOR POSTING TO CASH CONTROL FILE POSITION = 77; VALID VALUES = F F78 ATTEMPT TO ESTAB DUP RECORD ON CASH CONT FILE POSITION = 78; VALID VALUES = F F79 NO MATCH FOR POSTING TO GRANT/PROJECT FILE POSITION = 79; VALID VALUES = F F80 ATTEMPT TO ESTAB DUP REC ON GRANT/PROJ FILE POSITION = 80; VALID VALUES = F
Type
NVARCHAR(40)
Variable length string of up to 40 characters.
Values
F
=
FATAL
BLANK
=
FATAL
Name
AFRS UPDATE INDICATOR
Description
A CODE INDICATING THE ACTION TO BE TAKEN WITH A TABLE ENTRY.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
D
=
DELETE
A
=
ADD
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
AFRS PROGRAM INDEX
Name
AFRS PROGRAM INDEX KEY
Description
THE CONCATENATION OF AFRS_PRG_INDX AND BIEN TO FORM THE KEY TO THE AFRS_PRG_INDX_M.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
TITLE
Description
A DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTITY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
AFRS PROGRAM
Description
THE PROGRAM THAT WILL BE REPORTED TO AFRS FOR AN INTERNALLY-USED PROGRAM CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
AFRS SUBPROGRAM
Description
THE SUBPROGRAM THAT WILL BE REPORTED TO AFRS FOR AN INTERNALLY-USED SUBPROGRAM.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
AFRS ACTIVITY
Description
A TWO POSITION FIELD THAT IDENTIFIES UNIQUE OR SPECIFIC DIVISIONS WITHIN AN AGNECY'S SUB- PROGRAMS. THIS IS A FURTHER DEFINITION OF A SUB-PROGRAM.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
AFRS SUBACTIVITY
Description
A TWO DIGIT FIELD THAT IDENTIFIES UNIQUE OR SPECIFIC DIVISIONS WITHIN AN AGENCY'S ACTIVITY. THIS IS A FURTHER DEFINITION OF ACTIVITIES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
AFRS TASK
Description
A TWO DIGIT FIELD THAT IDENTIFIES UNIQUE OR SPECIFIC DIVISIONS WITHIN AN AGENCY'S SUB- ACTIVITIES. THIS IS A FURTHER DEFINITION OF SUB-ACTIVITIES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
ALLOTMENT PROGRAM LEVEL INDICATOR
Description
THIS ELEMENT DEFINES THE LEVEL OF ALLOTMENT CONTROL FOR THE AFRS PROGRAM INDEX. THE SYSTEM EDITS THE PROGRAM INDEX TO DETERMINE THAT THE LEVEL AT WHICH THE ALLOTMENT CONTROL IS DEFINED IS ACTUALLY CONTAINED IN THE INDEX CODE. THIS APPLYS ONLY TO AFRS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
A
=
ALLOTMENTS BY FUND ONLY
B
=
ALLOTMENTS BY FUNCTION AND FUND
C
=
ALLOTMENTS BY PROGRAM AND FUND
D
=
ALLOTMENTS BY SUBPROGRAM AND FUND
E
=
ALLOTMENTS BY ACTIVITY AND FUND
F
=
ALLOTMENTS BY SUBACTIVITY AND FUND
G
=
ALLOTMENTS BY TASK AND FUND
Name
EDIT STATUS
Description
A CODE INDICATING THE EDITING STATUS OF A PARTICULAR CODE OR COMBINATION OF CODES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
A
=
ACTIVE
N
=
NON-ACCOUNTING
I
=
INACTIVE
D
=
DELETE
Name
AFRS UPDATE INDICATOR
Description
A CODE INDICATING THE ACTION TO BE TAKEN WITH A TABLE ENTRY.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
D
=
DELETE
C
=
CHANGE
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
AFRS PROGRAM TABLE
Name
AFRS PROGRAM
Description
THE PROGRAM THAT WILL BE REPORTED TO AFRS FOR AN INTERNALLY-USED PROGRAM CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE
Description
A DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTITY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
EDIT STATUS
Description
A CODE INDICATING THE EDITING STATUS OF A PARTICULAR CODE OR COMBINATION OF CODES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
I
=
INACTIVE
L
=
LIMITED
D
=
DELETE
N
=
NON-ACCOUNTING
Name
AFRS UPDATE INDICATOR
Description
A CODE INDICATING THE ACTION TO BE TAKEN WITH A TABLE ENTRY.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
C
=
CHANGE
D
=
DELETE
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
AFRS PROJECT TABLETHIS TABLE IS USED TO VERIFY THE APPR_INDX CAN BE USED FOR A PROJECT NUMBER.
Name
AFRS PROJECT NUMBER
Description
PROJECT NUMBER + BIENNIUM USED TO VERIFY THE APPROPRIATION IS VALID TO BE USED FOR THE PROJECT NUMBER.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
APPROPRIATION INDEX
Description
A THREE CHARACTER CODE USED TO REPRESENT A SPECIFIC COMBINATION OF FUND AND APPROPRIATION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
AFRS SUBPROGRAM TABLE
Name
AFRS SUBPROGRAM KEY
Description
THE CONCATENATION OF AFRS_PRG AND AFRS_SPRG TO FORM THE KEY TO THE AFRS_SPRG_TBL_M.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
TITLE
Description
A DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTITY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
EDIT STATUS
Description
A CODE INDICATING THE EDITING STATUS OF A PARTICULAR CODE OR COMBINATION OF CODES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
L
=
LIMITED
N
=
NON-ACCOUNTING
I
=
INACTIVE
D
=
DELETE
Name
AFRS UPDATE INDICATOR
Description
A CODE INDICATING THE ACTION TO BE TAKEN WITH A TABLE ENTRY.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
C
=
CHANGE
A
=
ADD
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
AFRS TRANSACTION CODE TABLE
Name
AFRS TRANSACTION CODE
Description
A THREE CHARACTER CODE ASSIGNED BY THE OFFICE OF FINANCIAL MANAGEMENT (OFM) WHICH IS USED BY THE AGENCY FINANCIAL REPORTING SYSTEM (AFRS) INTERFACE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE
Description
A DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTITY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
13TH MONTH TRANSACTION CODE
Description
A SPECIAL TRANSACTION CODE USED TO REPORT TRANSACTIONS OCCURRING IN THE 13TH MONTH.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
25TH MONTH TRANSACTION CODE
Description
A SPECIAL TRANSACTION CODE USED TO REPORT TRANSACTIONS OCCURRING IN THE 25TH MONTH.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
AFRS SUBSIDIARY ACCOUNT
Description
THE CURRENT DEFINITION OF USE FOR THIS FIELD IS FOR GENERAL LEDGER SUBSCRIPTS.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
AFRS BATCH TYPE
Description
A CODE INDICATING THE TYPE OF TRANSACTIONS IN A BATCH.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
TRANSACTION MODIFIER EDIT
Description
A CODE INDICATING WHETHER TRANSACTION MODIFIER IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
TRANSACTION REVERSE EDIT
Description
A CODE INDICATING WHETHER TRANSACTION REVERSE IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
ORGANIZATIONAL INDEX EDIT CODE
Description
A CODE INDICATING WHETHER AN ORGANIZATION INDEX CODE IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
APPROPRIATION INDEX EDIT
Description
THE ONE CHARACTER CODE TO INDICATE WHETHER THE APPROPRIATION INDEX IS A REQUIRED FIELD FOR A PARTICULAR TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
R
=
REQUIRED
N
=
NOT ALLOWED
Name
FUND EDIT
Description
A CODE INDICATING WHETHER FUND IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
FUND DETAIL EDIT
Description
A CODE INDICATING WHETHER FUND DETAIL IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
PROGRAM INDEX EDIT
Description
A CODE INDICATING WHETHER A PROGRAM INDEX CODE IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
SUBOBJECT EDIT
Description
A ONE CHARACTER CODE TO INDICATE WHETHER SUBOBJECT IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
SOURCE EDIT
Description
A CODE TO INDICATE WHETHER OR NOT MAJOR GROUP/ MAJOR SOURCE IS REQUIRED, OPTIONAL OR SHOULD NOT BE INCLUDED ON AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
PROJECT NUMBER EDIT
Description
A CODE INDICATING WHETHER PROJECT NUBMER IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
DOCUMENT NUMBER EDIT CODE
Description
A CODE ASSIGNED TO INDICATE WHETHER A DOCUMENT NUMBER IS REQUIRED AS PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
C
=
CARRY DOCUMENT NUMBER FORWARD FROM DETAIL TRANSACTION
N
=
NOT ALLOWED
Name
REFERENCE DOCUMENT EDIT
Description
A ONE CHARACTER CODE TO INDICATE WHETHER A REFERENCE DOCUMENT IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
R
=
REQUIRED
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
GENERAL LEDGER EDIT
Description
A CODE TO INDICATE WHETHER A GENERAL LEDGER IS A REQUIRED PART OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OPTIONAL
N
=
NOT ALLOWED
Name
SUBSIDIARY ACCOUNT EDIT
Description
A ONE CHARACTER CODE INDICATING WHETHER A SUBSIDIARY ACCOUNT IS REQUIRED ON AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NOT ALLOWED.
O
=
OPTIONAL
Name
AFRS WARRANT WRITING INDICATOR
Description
DEFINES THE EFFECT A SPECIFIC AFRS TRANSACTION CODE HAS ON THE AFRS/TAS WARRANT WRITING PROCESS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
CREATE WARRANT WRITING RECORD
2
=
RECORD "WALK-THRU" WARRANT
3
=
RECORD DISCOUNT/CREDIT MEMO
Name
DEBIT GENERAL LEDGER 1
Description
THE FIRST GENERAL LEDGER TO BE DEBITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CREDIT GENERAL LEDGER 1
Description
THE FIRST GENERAL LEDGER TO BE CREDITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
DEBIT GENERAL LEDGER 2
Description
THE SECOND GENERAL LEDGER TO BE DEBITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CREDIT GENERAL LEDGER 2
Description
THE SECOND GENERAL LEDGER TO BE CREDITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
DEBIT GENERAL LEDGER 3
Description
THE THIRD GENERAL LEDGER TO BE DEBITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CREDIT GENERAL LEDGER 3
Description
THE THIRD GENERAL LEDGER TO BE CREDITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
DEBIT GENERAL LEDGER 4
Description
THE FOURTH GENERAL LEDGER TO BE DEBITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CREDIT GENERAL LEDGER 4
Description
THE FOURTH GENERAL LEDGER TO BE CREDITED FOR A SPECIFIC TRANSACTION CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
EDIT STATUS
Description
A CODE INDICATING THE EDITING STATUS OF A PARTICULAR CODE OR COMBINATION OF CODES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
A
=
ACTIVE
D
=
DELETE
I
=
INACTIVE
N
=
NON-ACCOUNTING
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Description:
ACCOUNTS PAYABLE DATA BASE
ACCOUNTS PAYABLE ACH/EFT MASTERCONTAINS THE BANK TRANSIT AND ACCOUNT NUMBERS USED TO ELECTRONICALLY TRANSFER FUNDS.
Name
CUSTOMER ID
Description
THE CONCATENATION OF THE CUSTOMER NUMBER AND CUSTOMER TYPE WHICH UNIQUELY IDENTIFIES A CUSTOMER.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
BANK TRANSIT NUMBER
Description
A NUMBER ISSUED BY THE FEDERAL RESERVE WHICH IDENTIFIES THE BANK THE EMPLOYEE HAS DESIGNATED FOR DIRECT DEPOSIT OF THEIR PAYROLL CHECK.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
BANK ACCOUNT NUMBER
Description
THE SPECIFIC ACCOUNT WITHIN THE EMPLOYEE'S BANK WHERE THE PAYROLL CHECK IS TO BE DEPOSITED.
Type
NVARCHAR(18)
Variable length string of up to 18 characters.
Name
EFFECTIVE DATE
Description
THE DATE THE RECORD IS TO BECOME EFFECTIVE.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR EFF_DATE
Description
SQL FORMATTED DATE FOR EFF_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
EDIT STATUS
Description
A CODE INDICATING THE EDITING STATUS OF A PARTICULAR CODE OR COMBINATION OF CODES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
L
=
LIMITED
N
=
NON-ACCOUNTING
I
=
INACTIVE
D
=
DELETE
AP CHECK INVENTORY MASTER
Name
CHECK INVENTORY KEY
Description
THE KEY TO THE CHECK INVENTORY MASTER.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
LAST CHECK NUMBER
Description
DEFINTION: THE LAST CHECK NUMBER PRINTED.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
LAST VOUCHER
Description
THIS RECORDS LAST VOUCHER NUMBER FOR EFD VOUCHERS
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
CHECK MASTER
Name
CHECK KEY
Description
THE CONCATENATION OF CHK_NUM AND ST_WARRANT_IND FORM THE KEY TO THE AP_CHK_M.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
NAME
Description
THE NAME OF THE INDIVIDUAL OR ORGANIZATION.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
ID NUMBER/ID TYPE
Description
A FIELD THAT HAS THE ID NUMBER AND ID TYPE COMBINED. FIELD=ID_TYP FOLLOWED BY ID_NUM.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
CHECK DATE
Description
THE DATE A CHECK WAS PRODUCED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR CHK_DATE
Description
SQL FORMATTED DATE FOR CHK_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
NET CHECK AMOUNT
Description
THE AMOUNT FOR WHICH A CHECK WILL BE WRITTEN.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
CHECK STATUS
Description
A CODE TO INDICATE THE STATUS OF A CHECK.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
C
=
CANCELLED
H
=
HAND WRITTEN
R
=
CANCELLED AND RE-ISSUED
BLANK
=
NORMAL
Name
CHECK TYPE
Description
A ONE-CHARACTER CODE TO INDICATE THE ACTION TO BE TAKEN AND TYPE OF CHECK TO BE PRINTED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
S
=
STATE WARRANT
V
=
VENDOR PAYMENT ADVANCE
P
=
PAYROLL VENDOR PAYMENT
F
=
FINANCIAL AID
E
=
EFT PAYMENT
Name
CHECK BALANCE INDICATOR
Description
A CODE TO INDICATE WHETHER OR NOT A CHECK IS IN BALANCE. IF A CHECK IS IN BALANCE, THEN ACCOUNTING ENTRIES HAVE BEEN POSTED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
I
=
IN BALANCE
Name
CHECK CANCELLATION DATE
Description
THE DATE THAT A CHECK WAS CANCELLED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR CHK_CANCEL_DATE
Description
SQL FORMATTED DATE FOR CHK_CANCEL_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
CREDIT MEMO MASTER
Name
CREDIT MEMO NUMBER
Description
A UNIQUE NUMBER THAT IDENTIFIES A CREDIT MEMO.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
VENDOR CREDIT MEMO NUMBER
Description
THE IDENTIFYING NUMBER ON A CREDIT MEMO RECEIVED FROM A VENDOR.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
VENDOR NUMBER
Description
A CODE ASSIGNED TO REPRESENT A PARTICULAR VENDOR.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
CREDIT/DEBIT MEMO INDICATOR
Description
A CODE TO INDICATE WHETHER A DOCUMENT IS A CREDIT OR DEBIT MEMO.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
DR
=
DEBIT MEMO
Name
CREDIT MEMO DATE
Description
THE DATE THAT A PARTICULAR CREDIT MEMO WAS ISSUED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR CM_DATE
Description
SQL FORMATTED DATE FOR CM_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
CREDIT MEMO DESCRIPTION
Description
A DESCRIPTION ASSOCIATED WITH A CREDIT MEMO THAT WOULD BE USED IN AN ACCOUNTING TRANSACTION AND ON THE CHECK STUB.
Type
NVARCHAR(24)
Variable length string of up to 24 characters.
Name
CREDIT MEMO STATUS
Description
A CODE TO INDICATE THE STATUS OF A CREDIT MEMO.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
P
=
PENDING MANUAL REVIEW
Name
CREDIT MEMO AMOUNT
Description
THE AMOUNT THAT REPRESENTS THE VALUE OF THE CREDIT MEMO.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
CREDIT MEMO BALANCE
Description
THE AMOUNT OF A CREDIT OR DEBIT MEMO THAT HAS NOT BEEN APPLIED TO A CHECK WRITTEN TO A VENDOR.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
FINANCIAL ACCOUNTING STRUCTURE
Description
THE AGGREGATION OF DATA ELEMENTS THAT DEFINE THE FINANCIAL ACCOUNTING STRUCTURE INCLUDING TRANSACTION CODE, APPROPRIATION INDEX, PROGRAM INDEX, ORGANIZATION INDEX, SUBOBJECT, SUB- SUBOBJECT, MAJOR GROUP, MAJOR SOURCE, SUB-SOURCE BANK ACCOUNT AND DUE TO/FROM FUND.
Type
NVARCHAR(32)
Variable length string of up to 32 characters.
Name
CREDIT MEMO BALANCE INDICATOR
Description
A CODE TO INDICATE WHETHER OR NOT A CREDIT MEMO IS IN BALANCE. IF IT IS IN BALANCE, THEN ACCOUNTING ENTRIES HAVE BEEN POSTED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
O
=
OUT OF BALANCE
Name
ORDER NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO A PURCHASE ORDER FOR IDENTIFICATION PURPOSES.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
INVOICE MASTER
Name
INVOICE NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO EACH INVOICE.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
VENDOR INVOICE NUMBER
Description
THE IDENTIFYING NUMBER ON AN INVOICE RECEIVED FROM A VENDOR.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
INVOICE DATE
Description
FOR ACCOUNTS PAYABLE: BASED ON THE INVOICE DATE (MONTH,DAY,YEAR) IN CONJUNCTION WITH THE CURRENT DATE AND THE PAYMENT/DISCOUNT TERMS, THE PAYMENT DATE IS AUTOMATICALLY CALCULATED. FOR ACCOUNTS RECEIVABLE: THE DATE THE INVOICE WAS PRINTED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR INV_DATE
Description
SQL FORMATTED DATE FOR INV_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
INVOICE TYPE
Description
A CODE TO INDICATE THE TYPE OF INVOICE BEING PAID.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
2
=
INVOICE VOUCHER
Name
INVOICE STATUS
Description
A CODE INDICATING THE STATUS OF AN INVOICE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
U
=
UNPAID
O
=
OUT OF BALANCE
H
=
ON HOLD
C
=
CANCELLED
A
=
INVOICE HAS BEEN ACCRUED SINCE LAST MODIFICATION
Name
INVOICE DESCRIPTION
Description
A DESCRIPTION OF AN INVOICE TO BE PRINTED ON THE CHECK STUB.
Type
NVARCHAR(24)
Variable length string of up to 24 characters.
Name
CHECK TYPE
Description
A ONE-CHARACTER CODE TO INDICATE THE ACTION TO BE TAKEN AND TYPE OF CHECK TO BE PRINTED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
E
=
EFT PAYMENT
V
=
VENDOR PAYMENT ADVANCE
P
=
PAYROLL VENDOR PAYMENT
L
=
LOCAL
S
=
STATE WARRANT
Name
SEPARATE CHECK INDICATOR
Description
A ONE CHARACTER CODE USED TO DETERMINE IF A DOCUMENT AUTHORIZING PAYMENT SHOULD BE PAID ON AN INDIVIDUAL CHECK OR MAY BE COMBINED WITH OTHER PAYING DOCUMENTS TO PRINT A SINGLE CHECK FOR A VENDOR.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
S
=
PRINT A SEPARATE CHECK
Name
INVOICE TOTAL
Description
THE TOTAL INVOICE AMOUNT PRIOR TO COMPUTING ANY DISCOUNT.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
INVOICED SALES TAX
Description
THE AMOUNT OF SALES TAX CHARGED ON AN INVOICE.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
INVOICE SHIPPING/HANDLING
Description
THE AMOUNT OF SHIPPING/HANDLING CHARGED ON AN INVOICE.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
USE TAX INDICATOR
Description
A CODE TO INDICATE WHETHER OR NOT USE TAX IS TO BE COMPUTED ON AN INVOICE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO (DEFAULT)
Name
DISCOUNT PERCENT
Description
A PERCENT AT WHICH AN INVOICE WILL BE DISCOUNTED IF PAID WITHIN A SPECIFIC PERIOD OF TIME.
Type
NUMERIC(3,0)
Number of length 3 including 0 positions after the decimal.
Name
DISCOUNT DAYS
Description
THE NUMBER OF DAYS WITHIN WHICH AN INVOICE MUST BE PAID TO RECEIVE A DISCOUNT.
Type
NUMERIC(3,0)
Number of length 3 including 0 positions after the decimal.
Name
DISCOUNT DATE
Description
THE DATE BY WHICH AN INVOICE MUST BE PAID TO RECEIVE A DISCOUNT.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR DISC_DATE
Description
SQL FORMATTED DATE FOR DISC_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
DISCOUNT TAKEN INDICATOR
Description
A CODE TO INDICATE WHETHER OR NOT A DISCOUNT WAS OFFERED OR TAKEN ON A PARTICULAR INVOICE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
DISCOUNT OFFERED - NOT TAKEN
T
=
DISCOUNT OFFERED - TAKEN
Name
DISCOUNT AMOUNT
Description
THE AMOUNT OF VENDOR-OFFERED DISCOUNT TAKEN ON AN INVOICE BY MEETING A PAYMENT DEADLINE.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
FINAL PAYMENT DAYS
Description
THE NUMBER OF DAYS FROM THE INVOICE DATE UNTIL PAYMENT IS DUE.
Type
NUMERIC(3,0)
Number of length 3 including 0 positions after the decimal.
Name
SCHEDULED PAYMENT DATE
Description
THE DATE (YEAR,MONTH,DAY) AN INVOICE IS SCHEDULED TO BE PAID.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR SCHD_PYMT_DATE
Description
SQL FORMATTED DATE FOR SCHD_PYMT_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
INVOICE PAYMENT AMOUNT
Description
THE DOLLAR AMOUNT FOR WHICH PAYMENT IS TO BE MADE FOR A PARTICULAR INVOICE. THIS WOULD BE THE INVOICE TOTAL, LESS ANY DISCOUNT AMOUNT TAKEN.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
ACCOUNT AMOUNT TOTAL
Description
THE TOTAL OF ACCOUNT DISTRIBUTION AMOUNTS FOR A PARTICULAR DOCUMENT.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
BATCH IDENTIFIER
Description
A CODE USED TO IDENTIFY THE SOURCE OR TYPE OF BATCH OF ACCOUNTING TRANSACTIONS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
BATCH POSTING PERIOD
Description
THE ACCOUNTING PERIOD(YEAR,MONTH) TO WHICH A BATCH OF TRANSACTIONS ARE TO BE POSTED.
Type
NUMERIC(4,0)
Number of length 4 including 0 positions after the decimal.
Name
YEAR/QUARTER
Description
A THREE-POSITION ACADEMIC YEAR (I.E., 1984-85= 845) FOLLOWED BY THE QUARTER CODE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
RECEIVING DATE
Description
THE DATE GOODS OR SERVICES WERE RECEIVED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RECV_DATE
Description
SQL FORMATTED DATE FOR RECV_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
INTERDEPARTMENTAL COST TRANSFER MASTER
Name
DOCUMENT NUMBER
Description
THE NUMBER OF THE DOCUMENT THAT IS THE SOURCE OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
BATCH DATE
Description
THE DATES (MONTH,DAY,YEAR) THE ACCOUNTING EVENT OCCURED WHICH CORRESPONDS TO THE ACCOUNTING TRANSACTIONS IN THE BATCH.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR BTCH_DATE
Description
SQL FORMATTED DATE FOR BTCH_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
BATCH POSTING PERIOD
Description
THE ACCOUNTING PERIOD(YEAR,MONTH) TO WHICH A BATCH OF TRANSACTIONS ARE TO BE POSTED.
Type
NUMERIC(4,0)
Number of length 4 including 0 positions after the decimal.
Name
REFERENCE DOCUMENT NUMBER
Description
THE NUMBER OF THE DOCUMENT RELATED TO A DOCUMENT THAT IS THE SOURCE OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
TRANSACTION DESCRIPTION
Description
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
PETTY CASH MASTER
Name
ID NUMBER/ID TYPE
Description
A FIELD THAT HAS THE ID NUMBER AND ID TYPE COMBINED. FIELD=ID_TYP FOLLOWED BY ID_NUM.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
PETTY CASH STATUS
Description
A CODE INDICATING THE ACTIVITY RECORDED AGAINST A PETTY CASH FUND.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
PETTY CASH FUND AMOUNT
Description
THE AMOUNT OF MONEY CONTAINED IN A PARTICULAR PETTY CASH FUND.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
PETTY CASH FUND ESTABLISHED DATE
Description
THE DATE THAT A PARTICULAR PETTY CASH FUND WAS ESTABLISHED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR PETTY_CASH_DATE
Description
SQL FORMATTED DATE FOR PETTY_CASH_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
DOCUMENT NUMBER
Description
THE NUMBER OF THE DOCUMENT THAT IS THE SOURCE OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Values
SCHEDULED PAYMENT MASTER
Name
IDENTIFICATION NUMBER
Description
A NUMBER USED TO IDENTIFY A PERSON OR ORGANIZATION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
IDENTIFICATION NUMBER TYPE
Description
A CODE TO SPECIFICALLY IDENTIFY A TYPE OF PERSON OR ORGANIZATION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
E
=
EMPLOYEE
V
=
VENDOR
O
=
OTHER
Name
SCHEDULED PAYMENT DESCRIPTION
Description
A SHORT DESCRIPTION OF A SCHEDULED PAYMENT.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
SCHEDULED PAYMENT TYPE
Description
A CODE TO INDICATE THE TYPE OF SCHEDULED PAYMENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
SCHEDULED PAYMENT STATUS
Description
THE STATUS OF A SCHEDULED PAYMENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
SCHEDULED PAYMENT AMOUNT
Description
THE DOLLAR AMOUNT TO BE PAID MONTHLY ON A SCHEDULED BASIS.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
SCHEDULED PAYMENT START DATE
Description
THE BEGINNING MONTH AND YEAR THAT A SCHEDULED PAYMENT WILL BE PAID.
Type
NUMERIC(4,0)
Number of length 4 including 0 positions after the decimal.
Name
SCHEDULED PAYMENT END DATE
Description
THE FINAL MONTH AND YEAR THAT A SCHEDULED PAYMENT WILL BE PAID.
Type
NUMERIC(4,0)
Number of length 4 including 0 positions after the decimal.
Name
SCHEDULED PAYMENT DAY
Description
THE DAY OF THE MONTH WHEN A CHECK FOR A SCHEDULED PAYMENT SHOULD BE PRINTED.
Type
NUMERIC(2,0)
Number of length 2 including 0 positions after the decimal.
CHECK NUMBER/CREDIT MEMO CROSS REFERENCE
Name
CHECK KEY
Description
THE CONCATENATION OF CHK_NUM AND ST_WARRANT_IND FORM THE KEY TO THE AP_CHK_M.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
CREDIT MEMO NUMBER
Description
A UNIQUE NUMBER THAT IDENTIFIES A CREDIT MEMO.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
CREDIT MEMO AMOUNT
Description
THE AMOUNT THAT REPRESENTS THE VALUE OF THE CREDIT MEMO.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
Description
ARRAY MEMBER. SEE: CHC_CHK
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
Description
ARRAY MEMBER. SEE: CHC_CHK_STK
Type
NVARCHAR(1)
Variable length string of up to 1 characters.
Name
Description
ARRAY MEMBER. SEE: CHC_ST_WARRANT
Type
NVARCHAR(1)
Variable length string of up to 1 characters.
CREDIT MEMO ACCOUNT DETAIL
Name
CREDIT MEMO NUMBER
Description
A UNIQUE NUMBER THAT IDENTIFIES A CREDIT MEMO.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
FINANCIAL ACCOUNTING STRUCTURE
Description
THE AGGREGATION OF DATA ELEMENTS THAT DEFINE THE FINANCIAL ACCOUNTING STRUCTURE INCLUDING TRANSACTION CODE, APPROPRIATION INDEX, PROGRAM INDEX, ORGANIZATION INDEX, SUBOBJECT, SUB- SUBOBJECT, MAJOR GROUP, MAJOR SOURCE, SUB-SOURCE BANK ACCOUNT AND DUE TO/FROM FUND.
Type
NVARCHAR(32)
Variable length string of up to 32 characters.
Name
REIMBURSABLE CODE
Description
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
SUBSIDIARY ACCOUNT
Description
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
ACCOUNT AMOUNT
Description
THE DOLLAR AMOUNT ASSOCIATED WITH A PARTICULAR ACCOUNT DISTRIBUTION.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
ACCOUNT PERCENT
Description
THE PERCENTAGE USED TO DISTRIBUTE A DOLLAR TOTAL BETWEEN VARIOUS ACCOUNT DISTRIBUTIONS.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
AMOUNT/PERCENT INDICATOR
Description
A CODE TO INDICATE WHETHER A NUMBER ENTERED IS A DOLLAR AMOUNT OR A PERCENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
P
=
PERCENT
Name
TRANSACTION REVERSE
Description
A ONE CHARACTER CODE INDICATING THAT A PARTICULAR TRANSACTION IS TO BE REVERSED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
BLANK
=
NORMAL POSTING
Name
POSTING DETAIL INDICATOR
Description
A CODE INDICATING IF A TRANSACTION HAS BEEN POSTED
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
TRANSACTION HAS NOT BEEN POSTED
G
=
GENERATED TRANSACTION
E
=
TRANSACTION HAS BEEN PARTIALLY POSTED AND IS IN THE POSTING ERROR FILE TO BE REPROCESSED.
AP CREDIT MEMO/ID NUMBER CROSS REFERENCETHIS DATA SET PROVIDES A CROSS REFERENCE BETWEEN CREDIT MEMOS AND VENDOR NUMBERS.
Name
CREDIT MEMO NUMBER
Description
A UNIQUE NUMBER THAT IDENTIFIES A CREDIT MEMO.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
ID NUMBER/ID TYPE
Description
A FIELD THAT HAS THE ID NUMBER AND ID TYPE COMBINED. FIELD=ID_TYP FOLLOWED BY ID_NUM.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
INVOICE ACOUNT DETAILTHE ACCOUNTS TO BE CHARGED WHEN AN INVOICE IS PAID.
Name
INVOICE NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO EACH INVOICE.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
ORDER NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO A PURCHASE ORDER FOR IDENTIFICATION PURPOSES.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
FINANCIAL ACCOUNTING STRUCTURE
Description
THE AGGREGATION OF DATA ELEMENTS THAT DEFINE THE FINANCIAL ACCOUNTING STRUCTURE INCLUDING TRANSACTION CODE, APPROPRIATION INDEX, PROGRAM INDEX, ORGANIZATION INDEX, SUBOBJECT, SUB- SUBOBJECT, MAJOR GROUP, MAJOR SOURCE, SUB-SOURCE BANK ACCOUNT AND DUE TO/FROM FUND.
Type
NVARCHAR(32)
Variable length string of up to 32 characters.
Name
REIMBURSABLE CODE
Description
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
SUBSIDIARY ACCOUNT
Description
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
ACCOUNT AMOUNT
Description
THE DOLLAR AMOUNT ASSOCIATED WITH A PARTICULAR ACCOUNT DISTRIBUTION.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
ACCOUNT PERCENT
Description
THE PERCENTAGE USED TO DISTRIBUTE A DOLLAR TOTAL BETWEEN VARIOUS ACCOUNT DISTRIBUTIONS.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
AMOUNT/PERCENT INDICATOR
Description
A CODE TO INDICATE WHETHER A NUMBER ENTERED IS A DOLLAR AMOUNT OR A PERCENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
P
=
PERCENT
Name
ACCOUNT AMOUNT DISCOUNT
Description
THE AMOUNT OF DISCOUNT APPLIED TO A PARTICULAR ACCOUNT AMOUNT.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
ACCOUNT AMOUNT USE TAX
Description
THE AMOUNT OF USE TAX APPLIED TO A PARTICULAR ACCOUNT AMOUNT.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
TRANSACTION REVERSE
Description
A ONE CHARACTER CODE INDICATING THAT A PARTICULAR TRANSACTION IS TO BE REVERSED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
R
=
REVERSE POSTING
Name
AP INVOICE ACCOUNT STATUS
Description
THE CONCATINATION OF FOUR 1-CHARACTER FIELDS INDICATING A STATUS OR TRAIT OF A PARTICULAR ACCOUNT FOR AN ACCOUNTS PAYABLE INVOICE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CHARGE IDENTIFIER
Description
A UNIQUE NUMBER ASSIGNED TO EACH CHARGE IN CUSTOMER ACCOUNTS.
Type
NUMERIC(7,0)
Number of length 7 including 0 positions after the decimal.
Name
CUSTOMER REFERENCE
Description
USED TO INDICATE WHICH CUSTOMER IS BEING PAID BY A THIRD PARTY. WILL CONTAIN A CUSTOMER NUMBER.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
INVOICE NUMBER/CHECK NUMBER CROSS REFERENCEPROVIDES A CROSS REFERENCE BETWEEN INVOICE NUMBERS AND CHECK NUMBERS.
Name
INVOICE NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO EACH INVOICE.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
CHECK KEY
Description
THE CONCATENATION OF CHK_NUM AND ST_WARRANT_IND FORM THE KEY TO THE AP_CHK_M.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
INVOICE/ID NUMBER CROSS REFERENCEPROVIDES A CROSS REFERENCE BETWEEN INVOICES AND ID NUMBERS.
Name
INVOICE NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO EACH INVOICE.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
ID NUMBER/ID TYPE
Description
A FIELD THAT HAS THE ID NUMBER AND ID TYPE COMBINED. FIELD=ID_TYP FOLLOWED BY ID_NUM.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
INVOICE ITEM DETAIL
Name
INVOICE NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO EACH INVOICE.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
ORDER NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO A PURCHASE ORDER FOR IDENTIFICATION PURPOSES.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
ORDER ITEM NUMBER
Description
A NUMBER ASSIGNED TO EACH ITEM ON A PURCHASE ORDER.
Type
NUMERIC(3,0)
Number of length 3 including 0 positions after the decimal.
Name
QUANTITY
Description
THE NUMBER OF AN ITEM ORDERED, RECEIVED OR INVOICED.
Type
NUMERIC(4,0)
Number of length 4 including 0 positions after the decimal.
Name
UNIT
Description
HOW AN ITEM WILL BE PURCHASED, BY BOXES, CASES DOZENS, POUNDS ETC.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
UNIT PRICE
Description
THE COST PER UNIT FOR AN ITEM.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
INVOICE NUMBER/ORDER NUMBER CROSS REFERENCEPROVIDES A CROSS REFERENCE BETWEEN INVOICES FROM VENDORS AND ORDERS.
Name
ORDER NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO A PURCHASE ORDER FOR IDENTIFICATION PURPOSES.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
INVOICE NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO EACH INVOICE.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
LIQUIDATION INDICATOR
Description
A CODE TO IDENTIFY WHETHER OR NOT AN ENCUMBRANCE SHOULD BE LIQUIDATED IN FULL OR ONLY FOR THE AMOUNT BEING PAID.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
P
=
PARTIAL
INVOICE PAYEE DETAILWRITTEN ONLY FOR INVOICES WITH NO ID NUMBERS.
Name
INVOICE NUMBER
Description
A UNIQUE NUMBER ASSIGNED TO EACH INVOICE.
Type
NUMERIC(6,0)
Number of length 6 including 0 positions after the decimal.
Name
NAME
Description
THE NAME OF THE INDIVIDUAL OR ORGANIZATION.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
ADDRESS LINE 1
Description
THE FIRST LINE OF AN ADDRESS.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
ADDRESS LINE 2
Description
THE SECOND LINE OF AN ADDRESS
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
ZIP CODE
Description
A NINE (9) DIGIT NUMBER IDENTIFYING EACH POSTAL DELIVERY AREA IN THE UNITED STATES.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
VENDOR INVOICE/ID NUMBER CROSS REFERENCEPROVIDES A CROSS REFERENCE BETWEEN VENDOR NUMBER AND VENDOR INVOICE NUMBER
Name
ID NUMBER/ID TYPE
Description
A FIELD THAT HAS THE ID NUMBER AND ID TYPE COMBINED. FIELD=ID_TYP FOLLOWED BY ID_NUM.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
VENDOR INVOICE NUMBER
Description
THE IDENTIFYING NUMBER ON AN INVOICE RECEIVED FROM A VENDOR.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
INTERDEPARTMENTAL COST TRANSFER DETAIL
Name
DOCUMENT NUMBER
Description
THE NUMBER OF THE DOCUMENT THAT IS THE SOURCE OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
RECORD TYPE
Description
A TWO-CHARACTER CODE USED TO DISTINGUISH DIFFERENT RECORD FORMATS WITHIN THE SAME FILE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
FINANCIAL ACCOUNTING STRUCTURE
Description
THE AGGREGATION OF DATA ELEMENTS THAT DEFINE THE FINANCIAL ACCOUNTING STRUCTURE INCLUDING TRANSACTION CODE, APPROPRIATION INDEX, PROGRAM INDEX, ORGANIZATION INDEX, SUBOBJECT, SUB- SUBOBJECT, MAJOR GROUP, MAJOR SOURCE, SUB-SOURCE BANK ACCOUNT AND DUE TO/FROM FUND.
Type
NVARCHAR(32)
Variable length string of up to 32 characters.
Name
TRANSACTION REVERSE
Description
A ONE CHARACTER CODE INDICATING THAT A PARTICULAR TRANSACTION IS TO BE REVERSED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
R
=
REVERSE POSTING
Name
REIMBURSABLE CODE
Description
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
SUBSIDIARY ACCOUNT
Description
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
TRANSACTION AMOUNT
Description
THE DOLLAR AMOUNT ASSOCIATED WITH A PARTICULAR TRANSACTION.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
PETTY CASH ACCOUNT DETAIL
Name
ID NUMBER/ID TYPE
Description
A FIELD THAT HAS THE ID NUMBER AND ID TYPE COMBINED. FIELD=ID_TYP FOLLOWED BY ID_NUM.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
FINANCIAL ACCOUNTING STRUCTURE
Description
THE AGGREGATION OF DATA ELEMENTS THAT DEFINE THE FINANCIAL ACCOUNTING STRUCTURE INCLUDING TRANSACTION CODE, APPROPRIATION INDEX, PROGRAM INDEX, ORGANIZATION INDEX, SUBOBJECT, SUB- SUBOBJECT, MAJOR GROUP, MAJOR SOURCE, SUB-SOURCE BANK ACCOUNT AND DUE TO/FROM FUND.
Type
NVARCHAR(32)
Variable length string of up to 32 characters.
Name
ACCOUNT AMOUNT
Description
THE DOLLAR AMOUNT ASSOCIATED WITH A PARTICULAR ACCOUNT DISTRIBUTION.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
ACCOUNT PERCENT
Description
THE PERCENTAGE USED TO DISTRIBUTE A DOLLAR TOTAL BETWEEN VARIOUS ACCOUNT DISTRIBUTIONS.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
AMOUNT/PERCENT INDICATOR
Description
A CODE TO INDICATE WHETHER A NUMBER ENTERED IS A DOLLAR AMOUNT OR A PERCENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
A
=
AMOUNT
SCHEDULED PAYMENT ACCOUNT DETAIL
Name
DOCUMENT NUMBER
Description
THE NUMBER OF THE DOCUMENT THAT IS THE SOURCE OF AN ACCOUNTING TRANSACTION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
FINANCIAL ACCOUNTING STRUCTURE
Description
THE AGGREGATION OF DATA ELEMENTS THAT DEFINE THE FINANCIAL ACCOUNTING STRUCTURE INCLUDING TRANSACTION CODE, APPROPRIATION INDEX, PROGRAM INDEX, ORGANIZATION INDEX, SUBOBJECT, SUB- SUBOBJECT, MAJOR GROUP, MAJOR SOURCE, SUB-SOURCE BANK ACCOUNT AND DUE TO/FROM FUND.
Type
NVARCHAR(32)
Variable length string of up to 32 characters.
Name
REIMBURSABLE CODE
Description
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
SUBSIDIARY ACCOUNT
Description
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
ACCOUNT AMOUNT
Description
THE DOLLAR AMOUNT ASSOCIATED WITH A PARTICULAR ACCOUNT DISTRIBUTION.
Type
NUMERIC(12,2)
Number of length 12 including 2 positions after the decimal.
Name
ACCOUNT PERCENT
Description
THE PERCENTAGE USED TO DISTRIBUTE A DOLLAR TOTAL BETWEEN VARIOUS ACCOUNT DISTRIBUTIONS.
Type
NUMERIC(7,2)
Number of length 7 including 2 positions after the decimal.
Name
AMOUNT/PERCENT INDICATOR
Description
A CODE TO INDICATE WHETHER A NUMBER ENTERED IS A DOLLAR AMOUNT OR A PERCENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
P
=
PERCENT
Description:
APPLICANT TRACKING
APPLICANT MASTERTHIS SET CONTAINS ONE RECORD PER APPLICANT AND CONTAINS THE BASIC INFORMATION ABOUT A APPLICANTS TAN APPLICANT
Name
APPLICANT ID
Description
SEE EMP_ID
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
ADDRESS LINE 1
Description
THE FIRST LINE OF AN ADDRESS.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
ADDRESS LINE 2
Description
THE SECOND LINE OF AN ADDRESS
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
APPLICANT NAME
Description
SEE EMP_NAME
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
HOME TELEPHONE NUMBER
Description
THE TELEPHONE NUMBER OF THE EMPLOYEE'S PLACE OF RESIDENCE OR OTHER TELEPHONE NUMBER THROUGH WHICH THE EMPLOYEE MAY BE REACHED.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
MESSAGE PHONE NUMBER
Description
THE PHONE NUMBER AT WHICH A MESSAGE MAYBE LEFT FOR AN INDIVIDUAL OR ORGANIZATION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
MESSAGE PHONE NUMBER EXTENSION
Description
THE MESSAGE PHONE NUMBER EXTENSION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
ZIP CODE
Description
A NINE (9) DIGIT NUMBER IDENTIFYING EACH POSTAL DELIVERY AREA IN THE UNITED STATES.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
LAST ACTIVITY DATE
Description
THE DATE OF THE LAST ACTIVITY ON A RECORD IN THE DATASET.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR ACTV_DATE
Description
SQL FORMATTED DATE FOR ACTV_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
CITY/TOWN NAME
Description
THE NAME OF A CITY OR TOWN.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
COUNTRY
Description
THE NAME OF A COUNTRY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
STATE
Description
A STANDARD TWO-CHARACTER CODE ASSIGNED BY THE US POSTAL SERVICE TO EACH OF THE STATES/ PROVINCES IN THE UNITED STATES/CANADA AK - ALASKA AZ - ARIZONA AR - ARKANSAS CA - CALIFORNIA CO - COLORADO CT - CONNECTICUT DE - DELAWARE DC - DIST. OF COLUMBIA FL - FLORIDA GA - GEORGIA HI - HAWAII ID - IDAHO IL - ILLINOIS IN - INDIANA IA - IOWA KS - KANSAS KY - KENTUCKY LA - LOUISIANA ME - MAINE MD - MARYLAND MA - MASSACHUSETTS MI - MICHIGAN MN - MINNESOTA MS - MISSISSIPPI MO - MISSOURI MT - MONTANA NE - NEBRASKA NV - NEVADA NH - NEW HAMPSHIRE NJ - NEW JERSEY NM - NEW MEXICO NY - NEW YORK NC - NORTH CAROLINA ND - NORTH DAKOTA OH - OHIO OK - OKLAHOMA OR - OREGON PA - PENNSYLVANIA RI - RHODE ISLAND SC - SOUTH CAROLINA SD - SOUTH DAKOTA TN - TENNESSE TX - TEXAS UT - UTAH VT - VERMONT VA - VIRGINIA WA - WASHINGTON WV - WEST VIRGINIA WI - WISCONSIN WY - WYOMING AB - ALBERTA BC - BRITISH COLUMBIA MB - MANITOBA NB - NEW BRUNSWICK NF - NEWFOUNDLAND NS - NOVA SCOTIA ON - ONTARIO PE - PRINCE EDWARD ISLAND PQ - QUEBEC SK - SASKATCHEWAN
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
E_MAIL ADDRESS
Description
CONTAINS THE ELECTRONIC MAILING ADDRESS FOR SENDING "E-MAIL".
Type
NVARCHAR(40)
Variable length string of up to 40 characters.
Name
APPICANT LAST NAME
Description
THE APPLICANT'S SURNAME.
Type
NVARCHAR(26)
Variable length string of up to 26 characters.
Name
APPLICANT FIRST NAME
Description
THE APPLICANT'S GIVEN NAME.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
APPLICANT MIDDLE NAME
Description
THE APPLICANT'S MIDDLE NAME.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
APPLICANT PREFIX NAME
Description
THE ABBREVIATED PROFESSION OR PERSONAL TITLE ASSOCIATED WITH THE APPLICANT'S NAME.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
APPLICANT SUFFIX NAME
Description
THE ABBREVIATED IDENTIFIER, TITLE, DEGREE OR AFFILIATION ASSOCIATED WITH THE APPLICANT NAME.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
DOCUMENT SHELL DEFINITION MASTERA DATASET CONTAINING DOCUMENT SHELL DEFINITION DATA FOR PC WORD PROCESSOR SOFTWARE.
Name
DOCUMENT SHELL DEFINITION NAME
Description
THE NAME OF A DOCUMENT SHELL THAT DEFINES WHICH PRE-APP/APP DATA ELEMENT TO BE EXTRACTED FOR NOTIFICATION GENERATION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
DOCUMENT SHELL DEFINITION TITLE
Description
A DESCRIPTION TITLE OF THE DOCUMENT SHELL NAME.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
REVISION DATE
Description
THE DATE ON WHICH AN ENTRY HAS BEEN MODIFIED, ADDED, OR DELETED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR RVSN_DATE
Description
SQL FORMATTED DATE FOR RVSN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
POSITION VACANCY MASTERTHIS SET CONTAINS ONE RECORD PER OPEN POSITION TO BE FILLED AND CONTAINS SOME BASIC INFORMATION ABOUT AN OPEN POSITION.
Name
POSITION NUMBER
Description
A SIX DIGIT NUMBER WHICH IDENTIFIES THE SPECIFIC POSITION TO WHICH THE EMPLOYEE IS ASSIGNED.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
CLASSIFICATION OF INSTRUCTIONAL PROGRAMS
Description
A SIX DIGIT CODE USED FOR CLASSIFYING INSTRUCTIONAL PROGRAMS FOR EXTERNAL REPORTING THE CODES PROVIDE A STANDARD TERMINOLOGY FOR COLLECTING, REPORTING AND ANALYZING INFORMATION ABOUT INSTRUCTIONAL PROGRMS. THESE CODES REPLACE THE HEGIS TAXONOMY, INCLUDING O.E. (OFFICE OF EDUCATION) CODES.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
DEPARTMENT NUMBER
Description
A CODE TO UNIQUELY IDENTIFY A DEPARTMENT.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
EMPLOYEE ID
Description
A UNIQUE 9 DIGIT NUMBER ASSIGNED TO AN INDIVIDUAL FOR THE PURPOSES OF IDENTIFICATION THIS NUMBER NORMALLY THEIR SOCIAL SECURITY NUMBER.
Type
NVARCHAR(9)
Variable length string of up to 9 characters.
Name
HOME CAMPUS
Description
A CODE USED TO IDENTIFY THE EMPLOYEE'S HOME CAMPUS AT A MULTI-CAMPUS INSTITUTION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
JOB BEGIN DATE
Description
THE DATE ON WHICH A JOB BECOMES/BECAME EFFECTIVE
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
SQL FOR JOB_BEG
Description
SQL FORMATTED DATE FOR JOB_BEG
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
JOB CLASSIFICATION
Description
A CODE REPRESENTING A JOB CLASSIFICATION.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
MAIL STOP
Description
THE WORK LOCATION AT WHICH AN EMPLOYEE'S WORK RELATED MAIL SHOULD BE DELIVERED.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
POSTION LOCATION
Description
A USER DEFINED CODE USED TO IDENTIFY THE LOCATION OF THE POSITION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
POSITION TERM
Description
THE NUMBER OF MONTHS PER YEAR THAT THIS POSITION IS WORKED.
Type
NUMERIC(5,2)
Number of length 5 including 2 positions after the decimal.
Name
SHORT TITLE
Description
AN ABBREVIATED DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTRY.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
SUPERVISOR NAME
Description
THE NAME OF THE SUPERVISOR.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
WORK TELEPHONE NUMBER
Description
THE TELEPHONE NUMBER WHERE THE EMPLOYEE CAN BE REACHED DURING WORK HOURS.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
WORK PHONE EXTENSION
Description
THE EMPLOYEE'S WORK PHONE NUMBER EXTENSION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
UPDATE NEW EMPLOYEE TO EMP DATABASE
Description
EMPLOYEE UPDATE INDICATOR, SEE CODING.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO, DO NOT UPDATE NEW EMPLOYEE TO THE EMP DATABASE.
Name
EMPLOYEE UPDATE DATE
Description
THE DATE THAT A NEW EMPLOYEE WAS UPDATED TO THE EMPLOYEE DATABASE FROM THE APPLICANT DATABASE.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR UPD_EMP_DATE
Description
SQL FORMATTED DATE FOR UPD_EMP_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
LAST ACTIVITY DATE
Description
THE DATE OF THE LAST ACTIVITY ON A RECORD IN THE DATASET.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR ACTV_DATE
Description
SQL FORMATTED DATE FOR ACTV_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
POSITION TITLE
Description
THE TITLE OF A POSITION.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
POSITION PERCENT FULL TIME
Description
DEFINTION: THE PERCENT OF FULL TIME FOR A POSITION.
Type
NUMERIC(6,2)
Number of length 6 including 2 positions after the decimal.
Name
POSITION SCHEDULED WORK HOURS
Description
A USER DEFINED FIELD TO INDICATE THE WORK SCHEDULE THAT AN ENCUMBENT IN A POSTITON MAY WORK.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
PRE_APPLICANT MASTERTHIS SET CONTAINS ONE RECORD PER PRE-APPLICANT AND CONTAINS THE BASIC INFORMATION ABOUT A PREAPPLICANT.
Name
APPLICANT ID
Description
SEE EMP_ID
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
LAST ACTIVITY DATE
Description
THE DATE OF THE LAST ACTIVITY ON A RECORD IN THE DATASET.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR ACTV_DATE
Description
SQL FORMATTED DATE FOR ACTV_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
ADDRESS LINE 1
Description
THE FIRST LINE OF AN ADDRESS.
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
ADDRESS LINE 2
Description
THE SECOND LINE OF AN ADDRESS
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
APPLICANT NAME
Description
SEE EMP_NAME
Type
NVARCHAR(30)
Variable length string of up to 30 characters.
Name
DATE ENTERED
Description
THE DATE THE DATA WAS INITIALY ENTERED INTO THE SYSTEM.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR DATE_ENTR
Description
SQL FORMATTED DATE FOR DATE_ENTR
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
FOREIGN ADDRESS INDICATOR
Description
A CODE TO INDICATE IF AN ADDRESS IS FOREIGN OR DOMESTIC.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
F
=
FOREIGN ADDRESS.
Name
FULL_TIME/PART_TIME INDICATOR
Description
A CODE TO INDICATE IF AN EMPLOYEE IS FULL-TIME OR PART-TIME. FOR FACULTY, IF THEY ARE PAID ON THE FULL-TIME SALARY SCHEDULE, THEY SHOULD BE CODED FULL-TIME EVEN IF THEY ARE LESS THAN 100%.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
P
=
PART-TIME
Name
HOME TELEPHONE NUMBER
Description
THE TELEPHONE NUMBER OF THE EMPLOYEE'S PLACE OF RESIDENCE OR OTHER TELEPHONE NUMBER THROUGH WHICH THE EMPLOYEE MAY BE REACHED.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
MESSAGE PHONE NUMBER
Description
THE PHONE NUMBER AT WHICH A MESSAGE MAYBE LEFT FOR AN INDIVIDUAL OR ORGANIZATION.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
MESSAGE PHONE NUMBER EXTENSION
Description
THE MESSAGE PHONE NUMBER EXTENSION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
PREAPPLICANT MISCELLANEOUS FIELD 1
Description
USED FOR OPTIONAL INFORMATION AT THE USER'S DISCRETION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
PREAPPLICANT MISCELLANEOUS FIELD 2
Description
USED FOR OPTIONAL INFORMATION AT THE USER'S DISCRETION.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
ZIP CODE
Description
A NINE (9) DIGIT NUMBER IDENTIFYING EACH POSTAL DELIVERY AREA IN THE UNITED STATES.
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
ACKNOWLEDGMENT PRINT INDICATOR
Description
AN INDICATOR TO INDICATE IF AN ACKNOWLEDGMENT LETTER HAS BEEN PRINTED.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO,ACKNOWLEDGMENT HAS NOT BEEN PRINTED.
Name
E_MAIL ADDRESS
Description
CONTAINS THE ELECTRONIC MAILING ADDRESS FOR SENDING "E-MAIL".
Type
NVARCHAR(40)
Variable length string of up to 40 characters.
Name
APPICANT LAST NAME
Description
THE APPLICANT'S SURNAME.
Type
NVARCHAR(26)
Variable length string of up to 26 characters.
Name
APPLICANT FIRST NAME
Description
THE APPLICANT'S GIVEN NAME.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
APPLICANT MIDDLE NAME
Description
THE APPLICANT'S MIDDLE NAME.
Type
NVARCHAR(16)
Variable length string of up to 16 characters.
Name
APPLICANT PREFIX NAME
Description
THE ABBREVIATED PROFESSION OR PERSONAL TITLE ASSOCIATED WITH THE APPLICANT'S NAME.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
APPLICANT SUFFIX NAME
Description
THE ABBREVIATED IDENTIFIER, TITLE, DEGREE OR AFFILIATION ASSOCIATED WITH THE APPLICANT NAME.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
RECRUITMENT MASTERTHIS SET CONTAINS ONE RECORD PER RECRUITMENT AND CONTAINS SOME BASIC INFORMATION ABOUT THE RECRUITMENT.
Name
RECRUITMENT CODE
Description
A USER DEFINED CODE USED TO INDENTIFY UNIQUE RECRUITMENTS.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
LAST ACTIVITY DATE
Description
THE DATE OF THE LAST ACTIVITY ON A RECORD IN THE DATASET.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR ACTV_DATE
Description
SQL FORMATTED DATE FOR ACTV_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
RECRUITMENT CLOSING DATE
Description
THE CLOSING DATE OF THE RECRUITMENT PROCESS.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR RCRT_CLOSE_DATE
Description
SQL FORMATTED DATE FOR RCRT_CLOSE_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
RECRUITMENT OPENING DATE
Description
THE OPENING DATE OF THE RECRUITMENT PROCESS.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR RCRT_OPN_DATE
Description
SQL FORMATTED DATE FOR RCRT_OPN_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
RECRUITMENT TYPE
Description
A USER DEFINED CODE REPRESENTING THE TYPE OF RECRUITMENT. EX. OPEN PROMOTIONAL, LATERAL TRANSFER
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
TITLE
Description
A DISTINGUISHING NAME ASSOCIATED WITH A PARTICULAR CODE OR ENTITY.
Type
NVARCHAR(20)
Variable length string of up to 20 characters.
Name
JOB CLASSIFICATION
Description
A CODE REPRESENTING A JOB CLASSIFICATION.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
APPLICATION COMMENT DETAILTHIS SET CONTAINS ANY COMMENTS THE USER MAY HAVE ENTER FOR AN INDIVIDUAL APPLICATION.
Name
APPLICANT IN /APPLICATION NUMBER KEY
Description
THE CONCATENATION OF APPLICANT ID AND APPLICATION NUMBER.
Type
NVARCHAR(12)
Variable length string of up to 12 characters.
Name
COMMENT LINE OF 60 CHARACTERS
Description
USED FOR OPTIONAL INFORMATION AT THE USER'S DISCRETION.
Type
NVARCHAR(60)
Variable length string of up to 60 characters.
Name
LINE NUMBER
Description
A SEQUENTIAL NUMBER ASSIGNED TO A LINE.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
APPLICATION DETAILTHIS SET CONTAINS ONE RECORD FOR EACH APPLICATION AN INDIVIDUAL AS ON FILE.
Name
APPLICANT ID
Description
SEE EMP_ID
Type
NVARCHAR(10)
Variable length string of up to 10 characters.
Name
APPLICANT IN /APPLICATION NUMBER KEY
Description
THE CONCATENATION OF APPLICANT ID AND APPLICATION NUMBER.
Type
NVARCHAR(12)
Variable length string of up to 12 characters.
Name
RECRUITMENT CODE
Description
A USER DEFINED CODE USED TO INDENTIFY UNIQUE RECRUITMENTS.
Type
NVARCHAR(6)
Variable length string of up to 6 characters.
Name
LAST ACTIVITY DATE
Description
THE DATE OF THE LAST ACTIVITY ON A RECORD IN THE DATASET.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR ACTV_DATE
Description
SQL FORMATTED DATE FOR ACTV_DATE
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
APPLICATION NUMBER
Description
A USER DEFINED NUMBER FOR EACH APPLICATION ON FILE FOR AN APPLICANT.
Type
SMALLINT
Whole number between -2,147,483,648 and 2,147,483,647.
Name
APPLICANT TYPE
Description
DEFINTION: AN USER DEFINED CODE TO INDICATE THE TYPE OF APPLICANT. (EX. INSTITUTIONAL WIDE LAYOFF, ORGANIZATIONAL UNIT PROMOTIONAL, OPEN COMPETITIVE, ETC...)
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
PREFERENCE TYPE
Description
A USER DEFINED CODE TO INDICATE THE TYPE OF PREFERENCE GIVEN A PARTICULAR APPLICANT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Name
APPLICANT SCORE FIELD 1
Description
THE SCORE GIVEN AN APPLICANT IN THE FIRST PHASE OF THE APPLICANTION SCORING PROCESS.
Type
NUMERIC(6,1)
Number of length 6 including 1 positions after the decimal.
Name
APPLICANT SCORE FIELD 2
Description
THE SCORE GIVEN AN APPLICANT IN THE SECOND PHASE OF THE APPLICATION SCORING PROCESS.
Type
NUMERIC(6,1)
Number of length 6 including 1 positions after the decimal.
Name
APPLICANT SCORE FIELD 3
Description
THE SCORE GIVEN AN APPLICANT IN THE THRID PHASE OF THE APPLICATION SCORING PROCESS.
Type
NUMERIC(6,1)
Number of length 6 including 1 positions after the decimal.
Name
APPLICANT SCORE FIELD 4
Description
THE SCORE GIVEN AN APPLICANT IN THE FOURTH PHASE OF THE APPLICATION SCORING PROCESS.
Type
NUMERIC(6,1)
Number of length 6 including 1 positions after the decimal.
Name
CENSUS HISPANIC/SPANISH CODE
Description
A CLASSIFICATION OF HISPANIC/SPANISH ORIGINS WHICH ADHERES TO THE DATA CLASSIFICATIONS AS COLLECTED BY THE U.S. CENSUS QUESTIONNAIRE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
CENSUS RACE GROUP CODE
Description
A CLASSIFICATION OF RACE/ETHNIC CATEGORIES WHICH ADHERES TO THE DATA CLASSIFICATIONS AS COLLECTED BY THE U.S. CENSUS QUESTIONNAIRE.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
DATE ENTERED
Description
THE DATE THE DATA WAS INITIALY ENTERED INTO THE SYSTEM.
Type
NVARCHAR(8)
Variable length string of up to 8 characters.
Name
SQL FOR DATE_ENTR
Description
SQL FORMATTED DATE FOR DATE_ENTR
Type
DATE
Native SQL Date data type that can hold dates from 01-01-0001 through 12-31-9999.
Name
EDUCATIONAL LEVEL
Description
A CODE TO INDICATE AN EDUCATIONAL ACHIEVEMENT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
01
=
NO ACADEMIC CREDENTIALS
02
=
GRADE SCHOOL
03
=
SOME HIGH SCHOOL
04
=
HIGH SCHOOL DIPLOMA OR EQUIVALENT
05
=
TRADE CERTIFICATE
06
=
SOME COLLEGE
07
=
ASSOCIATE'S DEGREE
08
=
BACHELOR'S DEGREE
09
=
MASTER'S DEGREE
10
=
PROFESSIONAL DEGREE
11
=
OTHER DOCTORATE (DR. OF EDUC., DR. OF SCI.)
12
=
PHD
Name
EMPLOYEE HANDICAP STATUS
Description
A CODE TO CATEGORIZE THE DISABILITY/IMPAIRMENT FOR AN EMPLOYEE WITH HANDICAPS.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
AMBULATORY/MOBILITY
2
=
VISUAL
3
=
HEARING
4
=
MENTAL/PSYCHOLOGICAL
9
=
OTHER/UNKNOWN
5
=
MULTIPLE HANDICAPS
Name
EMPLOYEE RACE/ETHNIC
Description
A CODE TO DENOTE AN EMPLOYEE'S RACE/ETHNIC ORIGIN.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
1
=
ASIAN AMERICAN/PACIFIC ISLANDER
2
=
BLACK
3
=
NATIVE AMERICAN/ALASKAN NATIVE
4
=
HISPANIC
5
=
CAUCASIAN
Name
FULL_TIME/PART_TIME INDICATOR
Description
A CODE TO INDICATE IF AN EMPLOYEE IS FULL-TIME OR PART-TIME. FOR FACULTY, IF THEY ARE PAID ON THE FULL-TIME SALARY SCHEDULE, THEY SHOULD BE CODED FULL-TIME EVEN IF THEY ARE LESS THAN 100%.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
F
=
FULL-TIME
Name
MILITARY STATUS
Description
IDENTIFIES THE INDIVIDUAL'S CURRENT MILITARY STATUS FOR AFFIRMATIVE ACTION PURPOSES.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
DO
=
DISABLED VETERAN - OTHER THAN VIETNAM
NI
=
NOT INDICATED
CV
=
CAMPAIGN VETERAN
DC
=
DISABLED CAMPAIGN VETERAN
BLANK
=
NON-VETERAN
VV
=
VIETNAM ERA VETERAN
OV
=
OTHER VETERAN
SV
=
SPOUSE OF DECEASED VETERAN
Name
OVER FORTY YEARS OF AGE
Description
AN INDICATOR TO SHOW IF AN APPLICANT IS OVER 40 YEARS OF AGE OR NOT.
Type
NVARCHAR(2)
Variable length string of up to 2 characters.
Values
N
=
NO, NOT OVER 40 YEARS OF AGE.
Name
PREFERRED HOURS
Description
A USER DEFINED CODE TO INDICATE AN APPLICANTS PREFERENCE FOR WORK HOURS.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
PREFERRED LOCATION
Description
A USER DEFINED CODE TO INDICATE AN APPLICANTS PREFERENCE FOR POSTION LOCATION.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
PREFERRED SHIFT
Description
A USER DEFINED CODE TO INDICATE AN APPLICANTS PREFERENCE FOR A WORK SHIFT.
Type
NVARCHAR(4)
Variable length string of up to 4 characters.
Name
PREFERRED TERM
Description
A USER DEFINED CODE TO INDICATE AN APPLICANTS PREFEREN