SAD_STD_CON_NLD

(SQL Table)
 Index Back

OWO contract table

Table containing the OWO contracts /*Bug Id 29233402 - EA/VVA*/ Added fields adm_appl_nbr/appl_prog_nbr/prog_status

  • Parent Record Of SADAOHSNLDVWLNG SADAVBNLDVWLNG SADOWOAPP4VWLNG SADOWOAPPNLDLNG SADOWOPLANVWLNG SAD_AOHS_NLD_VW SAD_AVB_NLD_VW SAD_OWO_APP4_VW SAD_OWO_APP_NLD SAD_OWO_PLAN_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SAD_CONTRACTNR_NLD Number(12,0) DECIMAL(12) NOT NULL Unique OWO contract number.
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    5 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HCR_PERSON_NM_I

    6 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    7 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    8 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    9 ADDRESS_TYPE Character(4) VARCHAR2(4) NOT NULL Address Type
    10 NAME_TYPE Character(3) VARCHAR2(3) NOT NULL Type of Name
    11 DATE_SIGNED Date(10) DATE Date Signed
    12 SAD_OWO_PRINT_NLD Character(1) VARCHAR2(1) NOT NULL Print indicator for OWO contract

    Y/N Table Edit

    Default Value: N

    13 DURATION_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Duration (Hours)
    14 START_DATE Date(10) DATE NOT NULL Start Date for Gen Standing PO
    15 END_DATE Date(10) DATE NOT NULL End Date
    16 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    17 RECEIVED_FLAG Character(1) VARCHAR2(1) NOT NULL Received Flag

    Y/N Table Edit

    Default Value: N

    18 RETURN_DT Date(10) DATE Return Date
    19 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

    20 REASON Character(30) VARCHAR2(30) NOT NULL Reason
    21 DESCRLONG Long Character CLOB Long Description
    22 PRINT_STATUS Character(1) VARCHAR2(1) NOT NULL Use for printing
    N=Never Printed
    P=Previously Printed
    23 SAD_VOL_OPL_NLD Character(1) VARCHAR2(1) NOT NULL Indicator for complete or partial program. Incase partial, all plans are added as appendix type 1 to the contract.

    Y/N Table Edit

    Default Value: Y

    24 SAD_AOHS_NLD Character(1) VARCHAR2(1) NOT NULL Indicator for selecting the default appendix or manual selecting the appendixes from the AOHS appendix table

    Y/N Table Edit

    Default Value: N

    25 SAD_AVB_NLD Character(1) VARCHAR2(1) NOT NULL Indicator for selecting the default AVB appendix or manual selection of appendixes from the AVB appendix table.

    Y/N Table Edit

    Default Value: N

    26 SAD_OWO_VERS_NLD Character(1) VARCHAR2(1) NOT NULL OWO version
    27 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).

    Prompt Table: OPRID_VW

    28 SAD_CONTRN_OLD_NLD Number(12,0) DECIMAL(12) NOT NULL Old OWO contract number

    Prompt Table: SAD_OWO_CNTO_VW

    29 FIRST_NAME Character(30) VARCHAR2(30) NOT NULL First Name
    30 MIDDLE_NAME Character(30) VARCHAR2(30) NOT NULL MIDDLE_NAME
    31 NAME_ROYAL_PREFIX Character(15) VARCHAR2(15) NOT NULL Name Royal Prefix
    32 LAST_NAME Character(30) VARCHAR2(30) NOT NULL Last Name
    33 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    34 BIRTHDATE Date(10) DATE Date of Birth
    35 BIRTHPLACE Character(30) VARCHAR2(30) NOT NULL Birth Location
    36 BIRTHCOUNTRY Character(3) VARCHAR2(3) NOT NULL Birth Country
    37 SSR_NATIONAL_NLD Character(4) VARCHAR2(4) NOT NULL GBA Nationality Code
    38 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
    39 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
    40 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
    41 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
    42 CITY Character(30) VARCHAR2(30) NOT NULL City
    43 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
    44 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
    45 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code
    46 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
    47 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    48 SAD_MGR_FNM_NLD Character(30) VARCHAR2(30) NOT NULL First name of academic organization manager
    49 SAD_MGR_MNM_NLD Character(30) VARCHAR2(30) NOT NULL Middle name of academic organization manager
    50 SAD_MGR_RNM_NLD Character(15) VARCHAR2(15) NOT NULL Royal name prefix of academic organization manager
    51 SAD_MGR_LNM_NLD Character(30) VARCHAR2(30) NOT NULL Last name of academic organization manager
    52 SAD_MGR_SEX_NLD Character(1) VARCHAR2(1) NOT NULL Gender of academic organization manager
    53 NAME_AC Character(50) VARCHAR2(50) NOT NULL Alternate Character Name
    54 ADDRESS3_AC Character(55) VARCHAR2(55) NOT NULL Alternate Character Address 3
    55 NUM1_OTHER Character(6) VARCHAR2(6) NOT NULL Number 1 Other
    56 NUM2_OTHER Character(6) VARCHAR2(6) NOT NULL Number 2 Other
    57 POSTAL_OTHER Character(12) VARCHAR2(12) NOT NULL Postal Other
    58 CITY_AC Character(30) VARCHAR2(30) NOT NULL Alternate Character City
    59 SEX_FLG Character(1) VARCHAR2(1) NOT NULL Gender
    60 ADM_APPL_NBR Character(8) VARCHAR2(8) NOT NULL Application Nbr
    61 APPL_PROG_NBR Number(3,0) SMALLINT NOT NULL Application Program Nbr
    62 PROG_STATUS Character(4) VARCHAR2(4) NOT NULL Academic Program Status
    AC=Active in Program
    AD=Admitted
    AP=Applicant
    CM=Completed Program
    CN=Cancelled
    DC=Discontinued
    DE=Deceased
    DM=Dismissed
    LA=Leave of Absence
    PM=Prematriculant
    SP=Suspended
    WT=Waitlisted