PeopleSoft 9
Account Payables

Table Name DEPT_TBL

Table Description
DEPT_TBL
Columns
Name Datatype Is PK Is FK
SETID VARCHAR(5) Yes No
DEPTID VARCHAR(10) Yes No
EFFDT PSDATE Yes No
EFF_STATUS VARCHAR(1) No No
DESCR VARCHAR(30) No No
DESCRSHORT VARCHAR(10) No No
COMPANY VARCHAR(3) No No
SETID_LOCATION VARCHAR(5) No No
LOCATION VARCHAR(10) No No
TAX_LOCATION_CD VARCHAR(10) No No
MANAGER_ID VARCHAR(11) No No
MANAGER_POSN VARCHAR(8) No No
BUDGET_YR_END_DT SMALLINT No No
BUDGET_LVL VARCHAR(1) No No
GL_EXPENSE VARCHAR(35) No No
EEO4_FUNCTION VARCHAR(2) No No
CAN_IND_SECTOR VARCHAR(3) No No
ACCIDENT_INS VARCHAR(3) No No
SI_ACCIDENT_NUM VARCHAR(15) No No
HAZARD VARCHAR(4) No No
ESTABID VARCHAR(12) No No
RISKCD VARCHAR(6) No No
GVT_DESCR40 VARCHAR(40) No No
GVT_SUB_AGENCY VARCHAR(2) No No
GVT_PAR_LINE2 VARCHAR(10) No No
GVT_PAR_LINE3 VARCHAR(10) No No
GVT_PAR_LINE4 VARCHAR(10) No No
GVT_PAR_LINE5 VARCHAR(10) No No
GVT_PAR_DESCR2 VARCHAR(40) No No
GVT_PAR_DESCR3 VARCHAR(40) No No
GVT_PAR_DESCR4 VARCHAR(40) No No
GVT_PAR_DESCR5 VARCHAR(40) No No
CLASS_UNIT_NZL VARCHAR(5) No No
ORG_UNIT_AUS VARCHAR(4) No No
WORK_SECTOR_AUS VARCHAR(1) No No
APS_AGENT_CD_AUS SMALLINT No No
IND_COMMITTEE_BEL VARCHAR(3) No No
NACE_CD_BEL VARCHAR(10) No No
FTE_EDIT_INDC VARCHAR(1) No No
DEPT_TENURE_FLG VARCHAR(1) No No
TL_DISTRIB_INFO VARCHAR(1) No No
USE_BUDGETS VARCHAR(1) No No
USE_ENCUMBRANCES VARCHAR(1) No No
USE_DISTRIBUTION VARCHAR(1) No No
BUDGET_DEPTID VARCHAR(10) No No
DIST_PRORATE_OPTN VARCHAR(1) No No
HP_STATS_DEPT_CD VARCHAR(3) No No
HP_STATS_FACULTY VARCHAR(5) No No
MANAGER_NAME VARCHAR(30) No No
ACCOUNTING_OWNER VARCHAR(30) No No
COUNTRY_GRP VARCHAR(18) No No
BUDGETARY_ONLY VARCHAR(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 June 06, 2007