DEPT_TBL (SQL Table)	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.

DEPT_TBL

(SQL Table)

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.

Related Language Record: DEPT_TBL_LANG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

7 DESCRLONG Long Character CLOB Long Description

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

9 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

10 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

11 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code
Prompt Table: %RECNAME_EDIT

12 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID
Prompt Table: PERSONAL_DATA

13 MANAGER_POSN Character(8) VARCHAR2(8) NOT NULL Manager Position

14 BUDGET_YR_END_DT Number(4,0) SMALLINT NOT NULL Budget Year End Date

15 BUDGET_LVL Character(1) VARCHAR2(1) NOT NULL Budget Level
D=Department
J=Job Code
L=Line Item
N=None
P=Position Number
Default Value: N

16 GL_EXPENSE Character(35) VARCHAR2(35) NOT NULL GL Account #-Expense

17 EEO4_FUNCTION Character(2) VARCHAR2(2) NOT NULL U.S. EEO4 Function

18 CAN_IND_SECTOR Character(3) VARCHAR2(3) NOT NULL Canadian Industrial Sector

19 ACCIDENT_INS Character(3) VARCHAR2(3) NOT NULL Accident Insurance

20 SI_ACCIDENT_NUM Character(15) VARCHAR2(15) NOT NULL Social Insurance Accident #

21 HAZARD Character(4) VARCHAR2(4) NOT NULL Hazard

22 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

23 RISKCD Character(6) VARCHAR2(6) NOT NULL Risk Code

24 GVT_DESCR40 Character(40) VARCHAR2(40) NOT NULL Description

25 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

26 GVT_PAR_LINE2 Character(10) VARCHAR2(10) NOT NULL PAR Line 2 Department ID
Prompt Table: DEPT_TBL

27 GVT_PAR_LINE3 Character(10) VARCHAR2(10) NOT NULL PAR Line 3 Department ID
Prompt Table: DEPT_TBL

28 GVT_PAR_LINE4 Character(10) VARCHAR2(10) NOT NULL PAR Line 4 Department ID
Prompt Table: DEPT_TBL

29 GVT_PAR_LINE5 Character(10) VARCHAR2(10) NOT NULL PAR Line 5 Department ID
Prompt Table: DEPT_TBL

30 GVT_PAR_DESCR2 Character(40) VARCHAR2(40) NOT NULL PAR Line 2 Description

31 GVT_PAR_DESCR3 Character(40) VARCHAR2(40) NOT NULL PAR Line 3 Description

32 GVT_PAR_DESCR4 Character(40) VARCHAR2(40) NOT NULL PAR Line 4 Description

33 GVT_PAR_DESCR5 Character(40) VARCHAR2(40) NOT NULL PAR Line 5 Description

34 CLASS_UNIT_NZL Character(5) VARCHAR2(5) NOT NULL This field is used in the calculation of ARCI premiums.

35 ORG_UNIT_AUS Character(4) VARCHAR2(4) NOT NULL This code represents a unique organisational unit in which a member of the staff will perform their duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.

36 WORK_SECTOR_AUS Character(1) VARCHAR2(1) NOT NULL The work sector in which a function is being performed in one organisational unit by a member of staff in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
1=Higher Education
2=TAFE
3=VET (AMC Only)

37 APS_AGENT_CD_AUS Number(3,0) SMALLINT NOT NULL Australia Public Service (APS) Agency Code.

38 IND_COMMITTEE_BEL Character(3) VARCHAR2(3) NOT NULL The Joint Industrial Committee is used for Belgium to track the 'Paritair Comite' on company-, business unit- and department-level,

39 NACE_CD_BEL Character(10) VARCHAR2(10) NOT NULL The NACE Code is used for a generic systematic classification of companies within the European community. Format: AB12,34567 A - Section B - Subsection 12 - Division 345 - Group 6 - Class 7 - Subclass

40 FTE_EDIT_INDC Character(1) VARCHAR2(1) NOT NULL FTE Edit Indicator
H=Error
N=No Edit
S=Warning
Default Value: N

41 DEPT_TENURE_FLG Character(1) VARCHAR2(1) NOT NULL Can Grant Tenure
Y/N Table Edit
Default Value: N

42 TL_DISTRIB_INFO Character(1) VARCHAR2(1) NOT NULL Use TL Distribution?
Y/N Table Edit
Default Value: N

43 USE_BUDGETS Character(1) VARCHAR2(1) NOT NULL Use Budgeting Feature?
Y/N Table Edit
Default Value: N

44 USE_ENCUMBRANCES Character(1) VARCHAR2(1) NOT NULL Use Encumbrance Processing?
Y/N Table Edit
Default Value: N

45 USE_DISTRIBUTION Character(1) VARCHAR2(1) NOT NULL Use Paycheck Distribution?
Y/N Table Edit
Default Value: N

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

47 DIST_PRORATE_OPTN Character(1) VARCHAR2(1) NOT NULL Distribution Prorate Option
C=Calendar Days
N=Not Applicable
W=Work Days
Default Value: N

48 HP_STATS_DEPT_CD Character(3) VARCHAR2(3) NOT NULL Stats Can Dept Code

49 HP_STATS_FACULTY Character(5) VARCHAR2(5) NOT NULL Faculty Code

50 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Identifies the name of the manager of a specified department.

51 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner

52 COUNTRY_GRP Character(18) VARCHAR2(18) NOT NULL Country Group

53 BUDGETARY_ONLY Character(1) VARCHAR2(1) NOT NULL Budgetary Only
Y/N Table Edit
Default Value: N

54 RTBL_DATA Character(1) VARCHAR2(1) NOT NULL RTBL Data

55 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

56 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
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	DESCRSHORT	Character(10)	VARCHAR2(10) NOT NULL	Short Description
7	DESCRLONG	Long Character	CLOB	Long Description
8	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
9	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
10	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
11	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code Prompt Table: %RECNAME_EDIT
12	MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager ID Prompt Table: PERSONAL_DATA
13	MANAGER_POSN	Character(8)	VARCHAR2(8) NOT NULL	Manager Position
14	BUDGET_YR_END_DT	Number(4,0)	SMALLINT NOT NULL	Budget Year End Date
15	BUDGET_LVL	Character(1)	VARCHAR2(1) NOT NULL	Budget Level D=Department J=Job Code L=Line Item N=None P=Position Number Default Value: N
16	GL_EXPENSE	Character(35)	VARCHAR2(35) NOT NULL	GL Account #-Expense
17	EEO4_FUNCTION	Character(2)	VARCHAR2(2) NOT NULL	U.S. EEO4 Function
18	CAN_IND_SECTOR	Character(3)	VARCHAR2(3) NOT NULL	Canadian Industrial Sector
19	ACCIDENT_INS	Character(3)	VARCHAR2(3) NOT NULL	Accident Insurance
20	SI_ACCIDENT_NUM	Character(15)	VARCHAR2(15) NOT NULL	Social Insurance Accident #
21	HAZARD	Character(4)	VARCHAR2(4) NOT NULL	Hazard
22	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
23	RISKCD	Character(6)	VARCHAR2(6) NOT NULL	Risk Code
24	GVT_DESCR40	Character(40)	VARCHAR2(40) NOT NULL	Description
25	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency
26	GVT_PAR_LINE2	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 2 Department ID Prompt Table: DEPT_TBL
27	GVT_PAR_LINE3	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 3 Department ID Prompt Table: DEPT_TBL
28	GVT_PAR_LINE4	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 4 Department ID Prompt Table: DEPT_TBL
29	GVT_PAR_LINE5	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 5 Department ID Prompt Table: DEPT_TBL
30	GVT_PAR_DESCR2	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 2 Description
31	GVT_PAR_DESCR3	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 3 Description
32	GVT_PAR_DESCR4	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 4 Description
33	GVT_PAR_DESCR5	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 5 Description
34	CLASS_UNIT_NZL	Character(5)	VARCHAR2(5) NOT NULL	This field is used in the calculation of ARCI premiums.
35	ORG_UNIT_AUS	Character(4)	VARCHAR2(4) NOT NULL	This code represents a unique organisational unit in which a member of the staff will perform their duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
36	WORK_SECTOR_AUS	Character(1)	VARCHAR2(1) NOT NULL	The work sector in which a function is being performed in one organisational unit by a member of staff in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes. 1=Higher Education 2=TAFE 3=VET (AMC Only)
37	APS_AGENT_CD_AUS	Number(3,0)	SMALLINT NOT NULL	Australia Public Service (APS) Agency Code.
38	IND_COMMITTEE_BEL	Character(3)	VARCHAR2(3) NOT NULL	The Joint Industrial Committee is used for Belgium to track the 'Paritair Comite' on company-, business unit- and department-level,
39	NACE_CD_BEL	Character(10)	VARCHAR2(10) NOT NULL	The NACE Code is used for a generic systematic classification of companies within the European community. Format: AB12,34567 A - Section B - Subsection 12 - Division 345 - Group 6 - Class 7 - Subclass
40	FTE_EDIT_INDC	Character(1)	VARCHAR2(1) NOT NULL	FTE Edit Indicator H=Error N=No Edit S=Warning Default Value: N
41	DEPT_TENURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Can Grant Tenure Y/N Table Edit Default Value: N
42	TL_DISTRIB_INFO	Character(1)	VARCHAR2(1) NOT NULL	Use TL Distribution? Y/N Table Edit Default Value: N
43	USE_BUDGETS	Character(1)	VARCHAR2(1) NOT NULL	Use Budgeting Feature? Y/N Table Edit Default Value: N
44	USE_ENCUMBRANCES	Character(1)	VARCHAR2(1) NOT NULL	Use Encumbrance Processing? Y/N Table Edit Default Value: N
45	USE_DISTRIBUTION	Character(1)	VARCHAR2(1) NOT NULL	Use Paycheck Distribution? Y/N Table Edit Default Value: N
46	BUDGET_DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Budget with Department
47	DIST_PRORATE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Distribution Prorate Option C=Calendar Days N=Not Applicable W=Work Days Default Value: N
48	HP_STATS_DEPT_CD	Character(3)	VARCHAR2(3) NOT NULL	Stats Can Dept Code
49	HP_STATS_FACULTY	Character(5)	VARCHAR2(5) NOT NULL	Faculty Code
50	MANAGER_NAME	Character(30)	VARCHAR2(30) NOT NULL	Identifies the name of the manager of a specified department.
51	ACCOUNTING_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Accounting Owner
52	COUNTRY_GRP	Character(18)	VARCHAR2(18) NOT NULL	Country Group
53	BUDGETARY_ONLY	Character(1)	VARCHAR2(1) NOT NULL	Budgetary Only Y/N Table Edit Default Value: N
54	RTBL_DATA	Character(1)	VARCHAR2(1) NOT NULL	RTBL Data
55	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
56	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time