ORG_DEPT (SQL Table)	Index Back
Organization Department Table Use ORG_DEPT to store location information about a department. The address is maintained in the organization location record. Setting a location number in this record establishes the location for the department.

ORG_DEPT

(SQL Table)

Organization Department Table

Use ORG_DEPT to store location information about a department. The address is maintained in the organization location record. Setting a location number in this record establishes the location for the department.

Related Language Record: ORG_DEPT_LANG

Parent record: EXT_ORG_TBL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID
Prompt Table: EXT_ORG_TBL

2 ORG_DEPARTMENT Number(3,0) SMALLINT NOT NULL Department Nbr

3 EFFDT Date(10) DATE 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
Default Value: ORG_DEPT.DESCR

7 SCHOOL_DEPT_TYPE Character(3) VARCHAR2(3) NOT NULL School Department Type
ACD=Academic Department
ADM=Administrative Department

8 ORG_LOCATION Number(3,0) SMALLINT NOT NULL Location Nbr
Prompt Table: ORG_LOCATION

9 ORG_CONTACT Number(4,0) SMALLINT NOT NULL Contact Nbr
Prompt Table: ORG_CONTACT

10 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address

11 URL_ADDRESS Character(254) VARCHAR2(254) NOT NULL URL Address

12 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

13 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EXT_ORG_ID	Character(11)	VARCHAR2(11) NOT NULL	External Org ID Prompt Table: EXT_ORG_TBL
2	ORG_DEPARTMENT	Number(3,0)	SMALLINT NOT NULL	Department Nbr
3	EFFDT	Date(10)	DATE	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 Default Value: ORG_DEPT.DESCR
7	SCHOOL_DEPT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	School Department Type ACD=Academic Department ADM=Administrative Department
8	ORG_LOCATION	Number(3,0)	SMALLINT NOT NULL	Location Nbr Prompt Table: ORG_LOCATION
9	ORG_CONTACT	Number(4,0)	SMALLINT NOT NULL	Contact Nbr Prompt Table: ORG_CONTACT
10	EMAILID	Character(70)	VARCHAR2(70) NOT NULL	A user's E-mail address
11	URL_ADDRESS	Character(254)	VARCHAR2(254) NOT NULL	URL Address
12	LASTUPDDTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
13	LASTUPDOPRID	Character(30)	VARCHAR2(30) NOT NULL	Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.