GPDE_AL_DEPT (SQL Table)	Index Back
Departments Use DEPT_TBL to record information about the organizational entities in your company. Data also includes description, company code, location, and budget fields. Assign a DEPTID to each department, division, region, etc. which is used in your organizational hierarchy. The Tree Editor is used to build a hierarchy of these codes, and to identify and group them into the appropriate organizational levels. Department ID is used as the primary organizational identifier on payroll earnings records. It is also used as the basis for implementing organizational security for employee data. You can create multiple DEPT_TBL records for a department, each with a unique effective date.

GPDE_AL_DEPT

(SQL Table)

Departments

Use DEPT_TBL to record information about the organizational entities in your company. Data also includes description, company code, location, and budget fields. Assign a DEPTID to each department, division, region, etc. which is used in your organizational hierarchy. The Tree Editor is used to build a hierarchy of these codes, and to identify and group them into the appropriate organizational levels. Department ID is used as the primary organizational identifier on payroll earnings records. It is also used as the basis for implementing organizational security for employee data. You can create multiple DEPT_TBL records for a department, each with a unique effective date.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SETID_TBL

2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: DEPT_TBL.EFFDT

4 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

5 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	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SETID_TBL
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: DEPT_TBL.EFFDT
4	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
5	SRC_BANK_ID	Character(8)	VARCHAR2(8) NOT NULL	Source Bank ID Prompt Table: SRC_BANK