ACAD_ORG_HR_OWN (SQL Table)	Index Back
Acad Org HR Owner Tbl Use ACAD_ORG_TBL table to record information about the organizational entities in your academic organization. Assign an ACAD_ORG to each college, department, division, 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. You can create multiple ACAD_ORG records for an academic organization, each with a unique effective date.

ACAD_ORG_HR_OWN

(SQL Table)

Acad Org HR Owner Tbl

Use ACAD_ORG_TBL table to record information about the organizational entities in your academic organization. Assign an ACAD_ORG to each college, department, division, 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. You can create multiple ACAD_ORG records for an academic organization, each with a unique effective date.

Parent record: ACAD_ORG_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization
Prompt Table: ACAD_ORG_TBL

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

3 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
Prompt Table: DEPT_TBL
Set Control Field: INSTITUTION

4 PERCENT_OWNED Number(7,3) DECIMAL(6,3) NOT NULL Percent Owned

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACAD_ORG	Character(10)	VARCHAR2(10) NOT NULL	Academic Organization Prompt Table: ACAD_ORG_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	DEPTID	Character(10)	VARCHAR2(10) NOT NULL	Department Prompt Table: DEPT_TBL Set Control Field: INSTITUTION
4	PERCENT_OWNED	Number(7,3)	DECIMAL(6,3) NOT NULL	Percent Owned