SCH_PGM_CDPrompt Table: INTL_SCHPGM_TBL
CONTACT_NBRLANGUAGE_CDINT_CTCT_TL_LNG(SQL Table) |
Index Back |
|---|---|
Internatl School/Pgm ContactsINTL_CONTCT_TBL 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 contact person at a school. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCH_PGM_CD |
Character(6) | VARCHAR2(6) NOT NULL |
School/Program Code
Prompt Table: INTL_SCHPGM_TBL |
| 2 | CONTACT_NBR |
Number(3,0) | SMALLINT NOT NULL | Contact Number |
| 3 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 4 | CONTACT_TITLE | Character(35) | VARCHAR2(35) NOT NULL | Contact Title |
| 5 | CONTACT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Contact Type |