DEPT_TBL_EFF_VW

(SQL View)
 Index Back

Departments

05/24/99 The HRMS DEPT_TBL definition has been synchronized with the ERP definition. Any changes made to the HRMS definition must be made to ERP definition. Use DEPT_TBL to record information about the organizational entities in your company. Data also includes description, company code, location, and budget fields. Assign a DEPTID to each department, division, region, etc. which is used in your organizational hierarchy. The Tree Editor is used to build a hierarchy of these codes, and to identify and group them into the appropriate organizational levels. Department ID is used as the primary organizational identifier on payroll earnings records. It is also used as the basis for implementing organizational security for employee data. You can create multiple DEPT_TBL records for a department, each with a unique effective date.

SELECT A.SETID , A.DEPTID , A.EFFDT , A.EFF_STATUS , A.DESCR , A.DESCRSHORT ,COMPANY ,SETID_LOCATION ,LOCATION ,TAX_LOCATION_CD ,MANAGER_ID , MANAGER_POSN ,BUDGET_YR_END_DT ,BUDGET_LVL ,GL_EXPENSE , %subrec(DEPT_TBLUSA_SBR,a) , %subrec(DEPT_TBLCAN_SBR,a) , %subrec(DEPT_TBLGER_SBR,a) , %subrec(DEPT_TBLFRA_SBR,a) , %subrec(DEPT_TBLBEL_SBR,a) , %subrec(DEPT_TBLFED_SBR,a) ,FTE_EDIT_INDC , DEPT_TENURE_FLG , TL_DISTRIB_INFO , USE_BUDGETS , USE_ENCUMBRANCES , USE_DISTRIBUTION , BUDGET_DEPTID , HP_STATS_DEPT_CD , HP_STATS_FACULTY , %subrec(DEPT_TBLERP_SBR,a) FROM PS_DEPT_TBL A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_DEPT_TBL B WHERE B.SETID = A.SETID AND B.DEPTID = A.DEPTID AND B.EFFDT <= %CurrentDateIn)

  • Related Language Record: DEPT_TBL_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_01

    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 EFFDT Date(10) DATE NOT NULL 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
    7 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    8 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location SetID

    Prompt Table: SET_LOC_DEP_VW

    9 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: SET_LOC_VW

    10 TAX_LOCATION_CD Character(10) VARCHAR2(10) NOT NULL Tax Location Code

    Prompt Table: %RECNAME_EDIT

    11 MANAGER_ID Character(11) VARCHAR2(11) NOT NULL Manager ID

    Prompt Table: PERSON

    12 MANAGER_POSN Character(8) VARCHAR2(8) NOT NULL Manager Position

    Prompt Table: POSITION_DATA

    13 BUDGET_YR_END_DT Number(4,0) SMALLINT NOT NULL Budget Year End Date
    14 BUDGET_LVL Character(1) VARCHAR2(1) NOT NULL Budget Level
    D=Department
    J=Job Code
    L=Line Item
    N=None
    P=Position Number

    Default Value: N

    15 GL_EXPENSE Character(35) VARCHAR2(35) NOT NULL GL Account #-Expense
    16 EEO4_FUNCTION Character(2) VARCHAR2(2) NOT NULL U.S. EEO4 Function
    01=Financial Administration
    02=Streets and Highways
    03=Public Welfare
    04=Police Protection
    05=Fire Protection
    06=Natural Resources
    07=Hospitals & Sanatoriums
    08=Health
    09=Housing
    10=Community Development
    11=Corrections
    12=Utilities & Transportation
    13=Sanitation & Sewage
    14=Employment Security
    15=Other
    99=Not Counted for EEO Reporting
    17 CAN_IND_SECTOR Character(3) VARCHAR2(3) NOT NULL Canadian Industrial Sector
    18 ACCIDENT_INS Character(15) VARCHAR2(15) NOT NULL Accident Insurance

    Prompt Table: ACCDT_INS_TBL

    19 SI_ACCIDENT_NUM Character(15) VARCHAR2(15) NOT NULL Social Insurance Accident #
    20 HAZARD Character(8) VARCHAR2(8) NOT NULL Hazard

    Prompt Table: ACCDT_INS_HAZ

    21 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID

    Prompt Table: ESTAB_COMP_VW

    22 RISKCD Character(6) VARCHAR2(6) NOT NULL Risk Code

    Prompt Table: ESTAB_RISK_VW
    Set Control Field: ESTABID

    23 IND_COMMITTEE_BEL Character(3) VARCHAR2(3) NOT NULL The Joint Industrial Committee is used for Belgium to track the 'Paritair Comite' on company-, business unit- and department-level,

    Prompt Table: UNION_TBL

    24 NACE_CD_BEL Character(10) VARCHAR2(10) NOT NULL The NACE Code is used for a generic systematic classification of companies within the European community. Format: AB12,34567 A - Section B - Subsection 12 - Division 345 - Group 6 - Class 7 - Subclass
    25 GVT_DESCR40 Character(40) VARCHAR2(40) NOT NULL Description Field
    26 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

    Prompt Table: GVT_SUBAGCY_TBL

    27 GVT_PAR_LINE2 Character(10) VARCHAR2(10) NOT NULL PAR Line 2 Department ID

    Prompt Table: DEPT_TBL

    28 GVT_PAR_LINE3 Character(10) VARCHAR2(10) NOT NULL PAR Line 3 Department ID

    Prompt Table: DEPT_TBL

    29 GVT_PAR_LINE4 Character(10) VARCHAR2(10) NOT NULL PAR Line 4 Department ID

    Prompt Table: DEPT_TBL

    30 GVT_PAR_LINE5 Character(10) VARCHAR2(10) NOT NULL PAR Line 5 Department ID

    Prompt Table: DEPT_TBL

    31 GVT_PAR_DESCR2 Character(40) VARCHAR2(40) NOT NULL PAR Line 2 Description
    32 GVT_PAR_DESCR3 Character(40) VARCHAR2(40) NOT NULL PAR Line 3 Description
    33 GVT_PAR_DESCR4 Character(40) VARCHAR2(40) NOT NULL PAR Line 4 Description
    34 GVT_PAR_DESCR5 Character(40) VARCHAR2(40) NOT NULL PAR Line 5 Description
    35 FTE_EDIT_INDC Character(1) VARCHAR2(1) NOT NULL FTE Edit Indicator
    H=Error
    N=No Edit
    S=Warning

    Default Value: N

    36 DEPT_TENURE_FLG Character(1) VARCHAR2(1) NOT NULL Can Grant Tenure

    Y/N Table Edit

    Default Value: N

    37 TL_DISTRIB_INFO Character(1) VARCHAR2(1) NOT NULL Use TL Distribution?

    Y/N Table Edit

    Default Value: N

    38 USE_BUDGETS Character(1) VARCHAR2(1) NOT NULL Use Comm. Acctg. / Budgeting

    Y/N Table Edit

    Default Value: N

    39 USE_ENCUMBRANCES Character(1) VARCHAR2(1) NOT NULL Use Encumbrance Processing

    Y/N Table Edit

    Default Value: N

    40 USE_DISTRIBUTION Character(1) VARCHAR2(1) NOT NULL Use Actuals Distribution

    Y/N Table Edit

    Default Value: N

    41 BUDGET_DEPTID Character(10) VARCHAR2(10) NOT NULL Budget with Department
    42 HP_STATS_DEPT_CD Character(3) VARCHAR2(3) NOT NULL Stats-Can Dept Code
    43 HP_STATS_FACULTY Character(5) VARCHAR2(5) NOT NULL Stats-Can Faculty Code

    Prompt Table: HP_STATS_FACLTY

    44 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
    45 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner
    46 COUNTRY_GRP Character(18) VARCHAR2(18) NOT NULL Country Group