INTL_SCHPGM

(SQL Table)
 Index Back

EE Dependent Schools/Programs

INTL_SCHPGM is one of several records in the International Assignment module that deals with enrollment of dependents in school or educational programs while the employee is on a foreign job assignment. Use this record to identify the school or program in which the dependent is enrolled.

  • 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: PERSON

    2 DEPENDENT_ID Character(2) VARCHAR2(2) NOT NULL Dependent ID

    Prompt Table: DEPENDENT_VW

    3 SCH_PGM_CD Character(6) VARCHAR2(6) NOT NULL School/Program Code

    Prompt Table: INTL_SCHPGM_TBL

    4 BEGIN_DT Date(10) DATE Begin Date
    5 END_DT Date(10) DATE end date
    6 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    7 AMOUNT Signed Number(20,3) DECIMAL(18,3) NOT NULL Commuting Allowance Paid Per Cycle.
    8 PAYMENT_FREQUENCY Character(1) VARCHAR2(1) NOT NULL Payment Frequency
    A=Annual
    B=Biweekly
    M=Monthly
    O=Onetime Payment
    Q=Quarterly
    S=Semimonthly
    W=Weekly