DEPTTBL_UPG (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.

DEPTTBL_UPG

(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.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPRDEFTBL_UPG.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: %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 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
Prompt Table: COMPANYTBL_UPG

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

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

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

11 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

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

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

14 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

35 TL_DISTRIB_INFO Character(1) VARCHAR2(1) NOT NULL Use TL Distribution?
Default Value: N

36 USE_BUDGETS Character(1) VARCHAR2(1) NOT NULL Use Budgeting Feature?
Default Value: N

37 USE_ENCUMBRANCES Character(1) VARCHAR2(1) NOT NULL Use Encumbrance Processing?
Default Value: N

38 USE_DISTRIBUTION Character(1) VARCHAR2(1) NOT NULL Use Paycheck Distribution?
Default Value: N

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

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

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

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

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

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPRDEFTBL_UPG.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: %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	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANYTBL_UPG
8	SETID_LOCATION	Character(5)	VARCHAR2(5) NOT NULL	Location SetID
9	LOCATION	Character(10)	VARCHAR2(10) NOT NULL	Location Code
10	TAX_LOCATION_CD	Character(10)	VARCHAR2(10) NOT NULL	Tax Location Code Prompt Table: %RECNAME_EDIT
11	MANAGER_ID	Character(11)	VARCHAR2(11) NOT NULL	Manager ID
12	MANAGER_POSN	Character(8)	VARCHAR2(8) NOT NULL	Manager Position
13	BUDGET_YR_END_DT	Number(4,0)	SMALLINT NOT NULL	Budget Year End Date
14	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
15	GL_EXPENSE	Character(35)	VARCHAR2(35) NOT NULL	GL Account #-Expense
16	EEO4_FUNCTION	Character(2)	VARCHAR2(2) NOT NULL	U.S. EEO4 Function
17	CAN_IND_SECTOR	Character(3)	VARCHAR2(3) NOT NULL	Canadian Industrial Sector
18	ACCIDENT_INS	Character(3)	VARCHAR2(3) NOT NULL	Accident Insurance
19	SI_ACCIDENT_NUM	Character(15)	VARCHAR2(15) NOT NULL	Social Insurance Accident #
20	HAZARD	Character(4)	VARCHAR2(4) NOT NULL	Hazard
21	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID
22	RISKCD	Character(6)	VARCHAR2(6) NOT NULL	Risk Code
23	GVT_DESCR40	Character(40)	VARCHAR2(40) NOT NULL	Description
24	GVT_SUB_AGENCY	Character(2)	VARCHAR2(2) NOT NULL	Sub-Agency
25	GVT_PAR_LINE2	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 2 Department ID Prompt Table: DEPT_TBL
26	GVT_PAR_LINE3	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 3 Department ID Prompt Table: DEPT_TBL
27	GVT_PAR_LINE4	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 4 Department ID Prompt Table: DEPT_TBL
28	GVT_PAR_LINE5	Character(10)	VARCHAR2(10) NOT NULL	PAR Line 5 Department ID Prompt Table: DEPT_TBL
29	GVT_PAR_DESCR2	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 2 Description
30	GVT_PAR_DESCR3	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 3 Description
31	GVT_PAR_DESCR4	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 4 Description
32	GVT_PAR_DESCR5	Character(40)	VARCHAR2(40) NOT NULL	PAR Line 5 Description
33	FTE_EDIT_INDC	Character(1)	VARCHAR2(1) NOT NULL	FTE Edit Indicator H=Error N=No Edit S=Warning Default Value: N
34	DEPT_TENURE_FLG	Character(1)	VARCHAR2(1) NOT NULL	Can Grant Tenure Y/N Table Edit Default Value: N
35	TL_DISTRIB_INFO	Character(1)	VARCHAR2(1) NOT NULL	Use TL Distribution? Default Value: N
36	USE_BUDGETS	Character(1)	VARCHAR2(1) NOT NULL	Use Budgeting Feature? Default Value: N
37	USE_ENCUMBRANCES	Character(1)	VARCHAR2(1) NOT NULL	Use Encumbrance Processing? Default Value: N
38	USE_DISTRIBUTION	Character(1)	VARCHAR2(1) NOT NULL	Use Paycheck Distribution? Default Value: N
39	DIST_PRORATE_OPTN	Character(1)	VARCHAR2(1) NOT NULL	Distribution Prorate Option C=Calendar Days N=Not Applicable W=Work Days Default Value: N
40	HP_STATS_DEPT_CD	Character(3)	VARCHAR2(3) NOT NULL	Stats Can Dept Code
41	HP_STATS_FACULTY	Character(5)	VARCHAR2(5) NOT NULL	Faculty Code
42	MANAGER_NAME	Character(30)	VARCHAR2(30) NOT NULL	Identifies the name of the manager of a specified department.
43	ACCOUNTING_OWNER	Character(30)	VARCHAR2(30) NOT NULL	Accounting Owner
44	COUNTRY_GRP	Character(18)	VARCHAR2(18) NOT NULL	Country Group