DEPT_TBL_EF_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 SETID ,DPT.DEPTID ,DPT.EFFDT ,DPT.EFF_STATUS ,DPT.DESCR ,DPT.DESCRSHORT ,DPT.COMPANY ,DPT.SETID_LOCATION ,DPT.LOCATION ,DPT.TAX_LOCATION_CD ,DPT.MANAGER_ID ,DPT.MANAGER_POSN ,DPT.BUDGET_YR_END_DT ,DPT.BUDGET_LVL ,DPT.GL_EXPENSE ,DPT.EEO4_FUNCTION ,DPT.CAN_IND_SECTOR ,DPT.ACCIDENT_INS ,DPT.SI_ACCIDENT_NUM ,DPT.HAZARD ,DPT.ESTABID ,DPT.RISKCD ,DPT.GVT_DESCR40 ,DPT.GVT_SUB_AGENCY ,DPT.GVT_PAR_LINE2 ,DPT.GVT_PAR_LINE3 ,DPT.GVT_PAR_LINE4 ,DPT.GVT_PAR_LINE5 ,DPT.GVT_PAR_DESCR2 ,DPT.GVT_PAR_DESCR3 ,DPT.GVT_PAR_DESCR4 ,DPT.GVT_PAR_DESCR5 ,DPT.FTE_EDIT_INDC ,DPT.DEPT_TENURE_FLG ,DPT.TL_DISTRIB_INFO ,DPT.USE_BUDGETS ,DPT.USE_ENCUMBRANCES ,DPT.USE_DISTRIBUTION ,DPT.BUDGET_DEPTID ,DPT.HP_STATS_DEPT_CD ,DPT.HP_STATS_FACULTY ,DPT.MANAGER_NAME ,DPT.ACCOUNTING_OWNER ,DPT.COUNTRY_GRP ,DPT.HP_RTBC_OPTION ,DPT.HP_AUTO_RTBC ,DPT.CLASS_UNIT_NZL ,DPT.ORG_UNIT_AUS ,DPT.WORK_SECTOR_AUS ,DPT.APS_AGENT_CD_AUS ,DPT.IND_COMMITTEE_BEL ,DPT.NACE_CD_BEL FROM PS_DEPT_TBL DPT WHERE DPT.EFFDT = ( SELECT MAX(EFFDT) FROM PS_DEPT_TBL WHERE DEPTID = DPT.DEPTID AND EFFDT <= %CurrentDateIn)

  • Related Language Record: DEPT_LNG_EF_VW

    • # 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_DEPT_VLD_VW

    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 Set ID

    Prompt Table: SET_LOC_VLD_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 Nbr
    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 GVT_DESCR40 Character(40) VARCHAR2(40) NOT NULL Description Field
    24 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

    Prompt Table: GVT_SUBAGCY_TBL

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: DEPT_TBL

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

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: HP_STATS_FACLTY

    42 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
    43 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner
    44 COUNTRY_GRP Character(18) VARCHAR2(18) NOT NULL Country Group
    45 HP_RTBC_OPTION Character(1) VARCHAR2(1) NOT NULL Real Time Budget Check Options
    A=All
    B=Batch Process Only
    C=Critical
    D=Deferred
    46 HP_AUTO_RTBC Character(1) VARCHAR2(1) NOT NULL Auto Real Time Budget Check indicator

    Y/N Table Edit

    Default Value: N

    47 CLASS_UNIT_NZL Character(5) VARCHAR2(5) NOT NULL This field is used in the calculation of ARCI premiums.

    Prompt Table: CLS_UNT_TBL_NZL

    48 ORG_UNIT_AUS Character(4) VARCHAR2(4) NOT NULL This code represents a unique organisational unit in which a member of the staff will perform their duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.

    Prompt Table: DTYA_ORGUNT_AUS

    49 WORK_SECTOR_AUS Character(1) VARCHAR2(1) NOT NULL The work sector in which a function is being performed in one organisational unit by a member of staff in respect of their current duties. This is an Australia specific code which is needed for DETYA electronic reporting purposes.
    1=Higher Education
    2=TAFE
    3=VET (AMC Only)
    50 APS_AGENT_CD_AUS Number(3,0) SMALLINT NOT NULL Australia Public Service (APS) Agency Code.
    51 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

    52 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