HCI_DEPT_VW

(SQL View)
 Index Back

HCI Department View

Campus Integration department view

SELECT A.SETID ,A.DEPTID ,A.DESCR ,A.DESCRSHORT ,A.COMPANY ,A.SETID_LOCATION ,A.LOCATION ,A.TAX_LOCATION_CD ,A.MANAGER_ID ,A.MANAGER_POSN ,A.BUDGET_YR_END_DT ,A.BUDGET_LVL ,A.GL_EXPENSE ,A.EEO4_FUNCTION ,A.CAN_IND_SECTOR ,A.ACCIDENT_INS ,A.SI_ACCIDENT_NUM ,A.HAZARD ,A.ESTABID ,A.RISKCD ,A.GVT_DESCR40 ,A.GVT_SUB_AGENCY ,A.GVT_PAR_LINE2 ,A.GVT_PAR_LINE3 ,A.GVT_PAR_LINE4 ,A.GVT_PAR_LINE5 ,A.GVT_PAR_DESCR2 ,A.GVT_PAR_DESCR3 ,A.GVT_PAR_DESCR4 ,A.GVT_PAR_DESCR5 ,A.FTE_EDIT_INDC ,A.DEPT_TENURE_FLG ,A.TL_DISTRIB_INFO ,A.USE_BUDGETS ,A.USE_ENCUMBRANCES ,A.USE_DISTRIBUTION ,A.BUDGET_DEPTID ,A.HP_STATS_DEPT_CD ,A.HP_STATS_DPCD_NW ,A.HP_STATS_FACULTY ,A.MANAGER_NAME ,A.ACCOUNTING_OWNER ,A.COUNTRY_GRP ,%subrec(DEPT_TBLNZL_SBR,A) ,%subrec(DEPT_TBLAUS_SBR,A) ,%subrec(DEPT_TBLBEL_SBR,A) FROM PS_DEPT_TBL A WHERE %EffdtCheck(DEPT_TBL A2, A, %CurrentDateIn) AND A.EFF_STATUS = 'A'

  • Related Language Record: HCI_DEPT_VWLANG

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

    Prompt Table: SET_VLD_HR_01

    2 DEPTID Character(10) VARCHAR2(10) NOT NULL Department
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    5 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    6 SETID_LOCATION Character(5) VARCHAR2(5) NOT NULL Location Set ID

    Prompt Table: SET_LOC_VLD_VW

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

    Prompt Table: SET_LOC_VW

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

    Prompt Table: %RECNAME_EDIT

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

    Prompt Table: HCR_SUP_ID_DVW

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

    Prompt Table: POSN_DATA_VW

    11 BUDGET_YR_END_DT Number(4,0) SMALLINT NOT NULL Budget Year End Date
    12 BUDGET_LVL Character(1) VARCHAR2(1) NOT NULL Budget Level
    D=Department
    J=Job Code
    L=Line Item
    N=None
    P=Position Number
    13 GL_EXPENSE Character(35) VARCHAR2(35) NOT NULL GL Account #-Expense
    14 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
    15 CAN_IND_SECTOR Character(3) VARCHAR2(3) NOT NULL Canadian Industrial Sector
    16 ACCIDENT_INS Character(15) VARCHAR2(15) NOT NULL Accident Insurance

    Prompt Table: ACCDT_INS_TBL

    17 SI_ACCIDENT_NUM Character(15) VARCHAR2(15) NOT NULL Social Insurance Accident Nbr
    18 HAZARD Character(8) VARCHAR2(8) NOT NULL Hazard

    Prompt Table: ACCDT_INS_HAZ

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

    Prompt Table: ESTAB_COMP_VW

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

    Prompt Table: ESTAB_RISK_VW
    Set Control Field: ESTABID

    21 GVT_DESCR40 Character(40) VARCHAR2(40) NOT NULL Description Field
    22 GVT_SUB_AGENCY Character(2) VARCHAR2(2) NOT NULL Sub-Agency

    Prompt Table: GVT_SUBAGCY_TBL

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: DEPT_TBL

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

    Prompt Table: DEPT_TBL

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Y/N Table Edit

    37 BUDGET_DEPTID Character(10) VARCHAR2(10) NOT NULL Budget with Department
    38 HP_STATS_DEPT_CD Character(3) VARCHAR2(3) NOT NULL Stats-Can Dept Code
    39 HP_STATS_DPCD_NW Character(2) VARCHAR2(2) NOT NULL CATS Department Code - New

    Prompt Table: HP_STATS_CIP_CD

    40 HP_STATS_FACULTY Character(5) VARCHAR2(5) NOT NULL Stats-Can Faculty Code

    Prompt Table: HP_STATS_FACLTY

    41 MANAGER_NAME Character(30) VARCHAR2(30) NOT NULL Manager Name
    42 ACCOUNTING_OWNER Character(30) VARCHAR2(30) NOT NULL Accounting Owner
    43 COUNTRY_GRP Character(18) VARCHAR2(18) NOT NULL Country Group
    44 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

    45 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

    46 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)
    47 APS_AGENT_CD_AUS Number(3,0) SMALLINT NOT NULL Australia Public Service (APS) Agency Code.
    48 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

    49 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