Skip to main content
Skip table of contents

Pre_Mig_Student_Details_Bkup (ver12.0.0)

This table holds a static copy of the data from the Student and StudentCoreFields tables prior to the execution of the Contact Migration. It is for diagnostic purposes only and should not be used for reporting. It will be deleted in a future release.

Note: For internal use only.

Column Name

Initial Version

Data Type

Description

Bkup_ID 

12.0.0

Number

Unique identifier assigned by the system.

City12.0.0

Varchar2(50)

Address City.
DCID12.0.0

Number(10,0)

DCID for related student. Internal use only.
Emerg_1_PType12.0.0

Varchar2(4000)

Phone Type for Emergency 1 Contact's Phone Number.
Emerg_1_Rel12.0.0

Varchar2(4000)

Emergency 1 Contact's relationship to student.
Emerg_2_PType12.0.0

Varchar2(4000)

Phone Type for Emergency 2 Contact's Phone Number.
Emerg_2_Rel12.0.0

Varchar2(4000)

Emergency 2 Contact's relationship to student.
Emerg_3_Phone12.0.0

Varchar2(4000)

Emergency Phone Number for Emergency Contact 3.
Emerg_3_PType12.0.0

Varchar2(4000)

Phone Type for Emergency 3 Contact's Phone Number.
Emerg_3_Rel12.0.0

Varchar2(4000)

Emergency 3 Contact's relationship to student.
Emerg_Contact_112.0.0

Varchar2(60)

Name of Emergency Contact 1 for student.
Emerg_Contact_212.0.0

Varchar2(60)

Name of Emergency Contact 2 for student.
Emerg_Contact_312.0.0

Varchar2(4000)

Name of Emergency Contact 3 for student.
Emerg_Phone_112.0.0

Varchar2(30)

Emergency Phone Number for Emergency Contact 1.
Emerg_Phone_212.0.0

Varchar2(30)

Emergency Phone Number for Emergency Contact 2.
Father12.0.0

Varchar2(60)

Father name.
Father_Employer12.0.0

Varchar2(4000)

Employer information for student's father.
Father_Home_Phone12.0.0

Varchar2(4000)

Home phone number for student's father.
FatherDayPhone12.0.0

Varchar2(4000)

Daytime phone number for student's father.
First_Name12.0.0

Varchar2(50)

Student first name.
Gender12.0.0

Varchar2(2)

Gender from the Students table
Geocode12.0.0

Varchar2(50)

Student Address Geocode string
Guardian_FN12.0.0

Varchar2(4000)

Guardian's first name.
Guardian_LN12.0.0

Varchar2(4000)

Guardian's last name.
Guardian_MN12.0.0

Varchar2(4000)

Guardian's middle name.
GuardianDayPhone12.0.0

Varchar2(4000)

Daytime phone number for student's guardian.
GuardianEmail12.0.0

CLOB

Email address(es) for student's guardian.
Home_Phone12.0.0

Varchar2(30)

Student Home Phone
Last_Name12.0.0

Varchar2(50)

Student last name
Mailing_City12.0.0

Varchar2(50)

Mailing City

Mailing_Geocode12.0.0

Varchar2(50)

Mailing Address Geocode
Mailing_State12.0.0

Varchar2(2)

Mailing State

Mailing_Street12.0.0

Varchar2(60)

Mailing Address Street Address
Mailing_Zip12.0.0

Varchar2(10)

Mailing Address Zip Code
Middle_Name12.0.0

Varchar2(30)

Student middle name
Mother12.0.0

Varchar2(60)

Mother name.
Mother_Employer12.0.0

Varchar2(4000)

Employer information for student's mother.
Mother_Home_Phone12.0.0

Varchar2(4000)

Home phone number for student's mother.
MotherDayPhone12.0.0

Varchar2(4000)

Daytime phone number for student's mother.
Person_ID12.0.0

Number(10,0)

Person_ID from Student table, pre-migration

State12.0.0

Varchar2(2)

Address State abbreviation
State_StudentNumber12.0.0

Varchar2(32)

State Student Number
Street12.0.0

Varchar2(60)

1st line of address
StudentEmail12.0.0

Varchar2(256)

Email address(es) for student
WhenCreated12.0.0

Timestamp(6)

The date and time when the record was created.
WhenModified12.0.0

Timestamp(6)

The date and time when the record was modified.
WhoCreated12.0.0

Varchar2(100)

The name of the person who created the record.
WhoModified12.0.0

Varchar2(100)

The name of the person who modified the record.
Zip12.0.0

Varchar2(10)

Zip-code
JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.