GPCH_TX_LAWEXPT

(SQL Table)
Index Back

GPCH_TX_LAWEXPT

LAW 2006

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

Default Value: PERSONAL_DATA.EMPLID

Prompt Table: PERSONAL_DATA

2 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
3 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

Prompt Table: COMPANY_TBL

4 GPCH_RC_FROM_DT Date(10) DATE From Date
5 GPCH_RC_TO_DT Date(10) DATE To Date
6 GPCH_TX_EXPT_STAT Character(1) VARCHAR2(1) NOT NULL Expatriate Status
0=Ignore Periods
1=Split Periods

Default Value: 0