GPDE_BK_PE_HMBK (SQL Table)	Index Back
Company Use COMPANY_TBL to identify the company or companies to which you can assign employees in this database.

GPDE_BK_PE_HMBK

(SQL Table)

Company

Use COMPANY_TBL to identify the company or companies to which you can assign employees in this database.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PAY_ENTITY Character(10) VARCHAR2(10) NOT NULL Pay Entity
Prompt Table: GP_PYENT

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: COMPANY_TBL.EFFDT

3 GPDE_AL_PAYMT_TYPE Character(1) VARCHAR2(1) NOT NULL Payment Type
1=Wages and Salaries
3=Taxes
4=Social Insurance
6=Capital Accumulation
7=Direct Life Insurance
8=Garnishments
9=External Transfer
B=BVV
L=U1/Sick Leave
M=U2/Maternity Leave
V=Advance Payments

4 SRC_BANK_ID Character(8) VARCHAR2(8) NOT NULL Source Bank ID
Prompt Table: SRC_BANK

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PAY_ENTITY	Character(10)	VARCHAR2(10) NOT NULL	Pay Entity Prompt Table: GP_PYENT
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: COMPANY_TBL.EFFDT
3	GPDE_AL_PAYMT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Payment Type 1=Wages and Salaries 3=Taxes 4=Social Insurance 6=Capital Accumulation 7=Direct Life Insurance 8=Garnishments 9=External Transfer B=BVV L=U1/Sick Leave M=U2/Maternity Leave V=Advance Payments
4	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: SRC_BANK