TL_DEPT_TBL1_VW (SQL View)	Index Back
Departments 05/24/99 The HRMS DEPT_TBL definition has been synchronized with the ERP definition. Any changes made to the HRMS definition must be made to ERP definition. 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.

TL_DEPT_TBL1_VW

(SQL View)

Departments

05/24/99 The HRMS DEPT_TBL definition has been synchronized with the ERP definition. Any changes made to the HRMS definition must be made to ERP definition. 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.

SELECT SETID , DEPTID , EFFDT , EFF_STATUS , DESCR , COMPANY , SETID_LOCATION , LOCATION , MANAGER_ID , BUDGET_DEPTID FROM PS_DEPT_TBL

Related Language Record: TL_DEPT_TB1_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID_DEPT Character(5) VARCHAR2(5) NOT NULL Department Set ID
Default Value: OPR_DEF_TBL_HR.SETID
Prompt Table: SET_VLD_HR_01

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

3 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
Default Value: A

5 DESCR Character(30) VARCHAR2(30) NOT NULL Description

6 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANY_TBL

7 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID
Prompt Table: SET_LOC_VLD_VW

8 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
Prompt Table: SET_LOC_VW

9 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID
Prompt Table: HCR_SUP_ID_DVW

10 BUDGET_DEPTID Character(10) VARCHAR2(10) NOT NULL Budget with Department

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID_DEPT	Character(5)	VARCHAR2(5) NOT NULL	Department Set ID Default Value: OPR_DEF_TBL_HR.SETID Prompt Table: SET_VLD_HR_01
2	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department
3	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive Default Value: A
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
6	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
7	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location Set ID Prompt Table: SET_LOC_VLD_VW
8	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code Prompt Table: SET_LOC_VW
9	MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager ID Prompt Table: HCR_SUP_ID_DVW
10	BUDGET_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Budget with Department