INTL_SCHPGM_PAY(SQL Table) |
Index Back |
|---|---|
EE Dependent School Pymt SchedINTL_SCHPGM_PAY 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 record how payment is made to the school or program in which the dependent is enrolled. |
| # | 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 | DT_DUE |
Date(10) | DATE | Due Date |
| 5 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |
| 6 | TOTAL_SCHEDULED | Number(19,3) | DECIMAL(18,3) NOT NULL | Total Scheduled Amount |
| 7 | EMPLR_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Employer Amount |
| 8 | EMPL_AMT | Number(19,3) | DECIMAL(18,3) NOT NULL | Employee Amount |
| 9 | PAID_UNPAID | Character(1) | VARCHAR2(1) NOT NULL |
Paid/Unpaid
P=Paid U=Unpaid Default Value: U |
| 10 | REIMB_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Reimbursement Status
N=Not Reimbursed R=Reimbursed U=Unreimbursable Default Value: N |