GPHK_QTR_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	GPHK_QTR_NUM	Number(2,0)	SMALLINT NOT NULL	A running serial number to allow users to enter multiple quarters information for a single employee.
3	COUNTRY	Character(3)	VARCHAR2(3) NOT NULL	Country Prompt Table: SCC_CNT_ADFMTVW
4	ADDRESS1	Character(55)	VARCHAR2(55) NOT NULL	Address 1
5	ADDRESS2	Character(55)	VARCHAR2(55) NOT NULL	Address 2
6	ADDRESS3	Character(55)	VARCHAR2(55) NOT NULL	Address 3
7	ADDRESS4	Character(55)	VARCHAR2(55) NOT NULL	Address 4
8	CITY	Character(30)	VARCHAR2(30) NOT NULL	City
9	NUM1	Character(6)	VARCHAR2(6) NOT NULL	Number 1
10	NUM2	Character(6)	VARCHAR2(6) NOT NULL	Number 2
11	HOUSE_TYPE	Character(2)	VARCHAR2(2) NOT NULL	House Type AB=House Boat Reference WW=House Trailer Reference
12	ADDR_FIELD1	Character(2)	VARCHAR2(2) NOT NULL	Address Field 1
13	ADDR_FIELD2	Character(4)	VARCHAR2(4) NOT NULL	Address Field 2
14	ADDR_FIELD3	Character(4)	VARCHAR2(4) NOT NULL	Address Field 3
15	COUNTY	Character(30)	VARCHAR2(30) NOT NULL	County
16	STATE	Character(6)	VARCHAR2(6) NOT NULL	State Prompt Table: STATE_TBL
17	POSTAL	Character(12)	VARCHAR2(12) NOT NULL	Postal
18	GEO_CODE	Character(11)	VARCHAR2(11) NOT NULL	Geo Code
19	IN_CITY_LIMIT	Character(1)	VARCHAR2(1) NOT NULL	In City Limit Y/N Table Edit
20	GPHK_QTR_DESC	Character(20)	VARCHAR2(20) NOT NULL	A descriptive text of the housing quarters provided to the employee.
21	GPHK_QTR_BGN_DT	Date(10)	DATE	The date on which an employee started occupying the quarter.
22	GPHK_QTR_END_DT	Date(10)	DATE	The date until when an employee started occupying the quarter.
23	GPHK_QTR_ER2L_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid by an Employer to a Landlord for an employee occupying a housing quarter
24	GPHK_QTR_EE2L_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid by an Employee to a Landlord for occupying a housing quarter
25	GPHK_QTR_ER2EE_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid to an Employee by the employer for occupying a housing quarter. This could be a rent refunded to the employee.
26	GPHK_QTR_EE2ER_AMT	Number(11,2)	DECIMAL(10,2) NOT NULL	Amount paid to an Employer by the employee for occupying a housing quarter. This could be a rent refunded to the employer.
27	GPHK_MNTHLY_RENT	Number(11,2)	DECIMAL(10,2) NOT NULL	Monthly Rent
28	GPHK_QTR_ER2L_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employer to Landlord total
29	GPHK_QTR_EE2L_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employee to Landlord Total
30	GPHK_QTR_ER2EE_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employer to Employee Total
31	GPHK_QTR_EE2ER_TOT	Number(11,2)	DECIMAL(10,2) NOT NULL	Quarter Employee to Employer Total
32	GPHK_RFND_RENT	Character(1)	VARCHAR2(1) NOT NULL	Refund of rent Y/N Table Edit