PERS_INST_REL

(SQL Table)
 Index Back

Instituional Relationship

PERS_INST_REL stores the relationship(s) that a person has with your institution.

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 ALUMNI_CUR Character(1) VARCHAR2(1) NOT NULL Current Alumni (L)

    Y/N Table Edit

    Default Value: N

    3 ALUMNI_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Alumni Manual Maint

    Y/N Table Edit

    Default Value: N

    4 ALUMNI_EVER Character(1) VARCHAR2(1) NOT NULL Was An Alumni

    Y/N Table Edit

    Default Value: N

    5 ALUMNI_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was an Alumni Manual Maint

    Y/N Table Edit

    Default Value: N

    6 STUDENT_CUR Character(1) VARCHAR2(1) NOT NULL Current Student (S)

    Y/N Table Edit

    Default Value: N

    7 STUDENT_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Student Manual Maint

    Y/N Table Edit

    Default Value: N

    8 STUDENT_EVER Character(1) VARCHAR2(1) NOT NULL Was A Student

    Y/N Table Edit

    Default Value: N

    9 STUDENT_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was a Student Manual Maint

    Y/N Table Edit

    Default Value: N

    10 EMPLOYEE_CUR Character(1) VARCHAR2(1) NOT NULL Current Employee (E)

    Y/N Table Edit

    Default Value: N

    11 EMPLOYEE_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Employee Manual Maint

    Y/N Table Edit

    Default Value: N

    12 EMPLOYEE_EVER Character(1) VARCHAR2(1) NOT NULL Was An Employee

    Y/N Table Edit

    Default Value: N

    13 EMPLOYEE_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was an Employee Manual Maint

    Y/N Table Edit

    Default Value: N

    14 PROSPECT_CUR Character(1) VARCHAR2(1) NOT NULL Current Prospect (P)

    Y/N Table Edit

    Default Value: N

    15 PROSPECT_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Prospect Manual Maint

    Y/N Table Edit

    Default Value: N

    16 PROSPECT_EVER Character(1) VARCHAR2(1) NOT NULL Was A Prospect

    Y/N Table Edit

    Default Value: N

    17 PROSPECT_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was a Prospect Manual Maint

    Y/N Table Edit

    Default Value: N

    18 APPLICANT_CUR Character(1) VARCHAR2(1) NOT NULL Current Applicant (A)

    Y/N Table Edit

    Default Value: N

    19 APPLICANT_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Currrent Applic Manual Maint

    Y/N Table Edit

    Default Value: N

    20 APPLICANT_EVER Character(1) VARCHAR2(1) NOT NULL Was An Applicant

    Y/N Table Edit

    Default Value: N

    21 APPLICANT_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was an Applicant Manual Maint

    Y/N Table Edit

    Default Value: N

    22 FIN_AID_CUR Character(1) VARCHAR2(1) NOT NULL Current Financial Aid (F)

    Y/N Table Edit

    Default Value: N

    23 FIN_AID_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Currrent Fin Aid Manual Maint

    Y/N Table Edit

    Default Value: N

    24 FIN_AID_EVER Character(1) VARCHAR2(1) NOT NULL Was In Financial Aid

    Y/N Table Edit

    Default Value: N

    25 FIN_AID_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was in Fin Aid Manual Maint

    Y/N Table Edit

    Default Value: N

    26 STDNT_FIN_CUR Character(1) VARCHAR2(1) NOT NULL Current Student Financial (I)

    Y/N Table Edit

    Default Value: N

    27 STDNT_FIN_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Stud Fin Manual Maint

    Y/N Table Edit

    Default Value: N

    28 STDNT_FIN_EVER Character(1) VARCHAR2(1) NOT NULL Was In Student Financials

    Y/N Table Edit

    Default Value: N

    29 STDNT_FIN_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Student Financial Manual Maint

    Y/N Table Edit

    Default Value: N

    30 RECRUITER_CUR Character(1) VARCHAR2(1) NOT NULL Current Recruiter (R)

    Y/N Table Edit

    Default Value: N

    31 RECRUITER_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Currrent Recruiter Man Maint

    Y/N Table Edit

    Default Value: N

    32 RECRUITER_EVER Character(1) VARCHAR2(1) NOT NULL Was A Recruiter

    Y/N Table Edit

    Default Value: N

    33 RECRUITER_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was a Recruiter Manual Maint

    Y/N Table Edit

    Default Value: N

    34 ADVISOR_CUR Character(1) VARCHAR2(1) NOT NULL Current Advisor (AVS)

    Y/N Table Edit

    Default Value: N

    35 ADVISOR_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Advisor Man Maint

    Y/N Table Edit

    Default Value: N

    36 ADVISOR_EVER Character(1) VARCHAR2(1) NOT NULL Was An Advisor

    Y/N Table Edit

    Default Value: N

    37 ADVISOR_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was an Advisor Manual Maint

    Y/N Table Edit

    Default Value: N

    38 INSTRCTOR_CUR Character(1) VARCHAR2(1) NOT NULL Current Instructor (INST)

    Y/N Table Edit

    Default Value: N

    39 INSTRCTOR_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Instructor Man Maint

    Y/N Table Edit

    Default Value: N

    40 INSTRCTOR_EVER Character(1) VARCHAR2(1) NOT NULL Was An Instructor

    Y/N Table Edit

    Default Value: N

    41 INSTRCTOR_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was an Instructor Manual Maint

    Y/N Table Edit

    Default Value: N

    42 FRIEND_CUR Character(1) VARCHAR2(1) NOT NULL Current Friend (FND)

    Y/N Table Edit

    Default Value: N

    43 FRIEND_CUR_MAN Character(1) VARCHAR2(1) NOT NULL Current Friend Manual Maint

    Y/N Table Edit

    Default Value: N

    44 FRIEND_EVER Character(1) VARCHAR2(1) NOT NULL Was A Friend

    Y/N Table Edit

    Default Value: N

    45 FRIEND_EVER_MAN Character(1) VARCHAR2(1) NOT NULL Was a friend Manual Maint

    Y/N Table Edit

    Default Value: N