PeopleSoft 9
Asset Management

Table Name DEPT_TBL

Table Description
DEPT_TBL
Columns
Name Datatype Is PK Is FK
SETID char(5) Yes No
DEPTID char(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS char(1) No No
DESCR char(30) No No
DESCRSHORT char(10) No No
COMPANY char(3) No No
SETID_LOCATION char(5) No No
LOCATION char(10) No No
TAX_LOCATION_CD char(10) No No
MANAGER_ID char(11) No No
MANAGER_POSN char(8) No No
BUDGET_YR_END_DT smallint No No
BUDGET_LVL char(1) No No
GL_EXPENSE char(35) No No
EEO4_FUNCTION char(2) No No
CAN_IND_SECTOR char(3) No No
ACCIDENT_INS char(3) No No
SI_ACCIDENT_NUM char(15) No No
HAZARD char(4) No No
ESTABID char(12) No No
RISKCD char(6) No No
GVT_DESCR40 char(40) No No
GVT_SUB_AGENCY char(2) No No
GVT_PAR_LINE2 char(10) No No
GVT_PAR_LINE3 char(10) No No
GVT_PAR_LINE4 char(10) No No
GVT_PAR_LINE5 char(10) No No
GVT_PAR_DESCR2 char(40) No No
GVT_PAR_DESCR3 char(40) No No
GVT_PAR_DESCR4 char(40) No No
GVT_PAR_DESCR5 char(40) No No
CLASS_UNIT_NZL char(5) No No
ORG_UNIT_AUS char(4) No No
WORK_SECTOR_AUS char(1) No No
APS_AGENT_CD_AUS smallint No No
IND_COMMITTEE_BEL char(3) No No
NACE_CD_BEL char(10) No No
FTE_EDIT_INDC char(1) No No
DEPT_TENURE_FLG char(1) No No
TL_DISTRIB_INFO char(1) No No
USE_BUDGETS char(1) No No
USE_ENCUMBRANCES char(1) No No
USE_DISTRIBUTION char(1) No No
BUDGET_DEPTID char(10) No No
DIST_PRORATE_OPTN char(1) No No
HP_STATS_DEPT_CD char(3) No No
HP_STATS_FACULTY char(5) No No
MANAGER_NAME char(30) No No
ACCOUNTING_OWNER char(30) No No
COUNTRY_GRP char(18) No No
BUDGETARY_ONLY char(1) No No
SYNCID int No No
SYNCDTTM PSDATETIME No No
Index
Name Type Unique Member
PS_DEPT_TBL PK Yes
PS0DEPT_TBL IE1 No
PSADEPT_TBL IE2 No
PSBDEPT_TBL IE3 No
Member(s) of "PS_DEPT_TBL" Index
SETID
DEPTID
EFFDT
Member(s) of "PS0DEPT_TBL" Index
MANAGER_NAME
SETID
DEPTID
EFFDT
Member(s) of "PSADEPT_TBL" Index
DEPTID
Member(s) of "PSBDEPT_TBL" Index
SYNCID

Published December 16, 2006