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 |