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 |