HCI_DEPT_EFF_VW

(SQL View)
 Index Back

HCI DEPT EFFECTIVE VIEW

Department effective date integration view for campus integration

SELECT SETID ,DEPTID ,EFFDT ,EFF_STATUS ,DESCR ,DESCRSHORT ,COMPANY ,SETID_LOCATION ,LOCATION ,TAX_LOCATION_CD ,MANAGER_ID ,MANAGER_POSN ,BUDGET_YR_END_DT ,BUDGET_LVL ,GL_EXPENSE ,EEO4_FUNCTION ,CAN_IND_SECTOR ,ACCIDENT_INS ,SI_ACCIDENT_NUM ,HAZARD ,ESTABID ,RISKCD ,GVT_DESCR40 ,GVT_SUB_AGENCY ,GVT_PAR_LINE2 ,GVT_PAR_LINE3 ,GVT_PAR_LINE4 ,GVT_PAR_LINE5 ,GVT_PAR_DESCR2 ,GVT_PAR_DESCR3 ,GVT_PAR_DESCR4 ,GVT_PAR_DESCR5 ,FTE_EDIT_INDC ,DEPT_TENURE_FLG ,TL_DISTRIB_INFO ,USE_BUDGETS ,USE_ENCUMBRANCES ,USE_DISTRIBUTION ,BUDGET_DEPTID ,HP_STATS_DEPT_CD ,HP_STATS_DPCD_NW ,HP_STATS_FACULTY ,MANAGER_NAME ,ACCOUNTING_OWNER ,COUNTRY_GRP ,CLASS_UNIT_NZL ,ORG_UNIT_AUS ,WORK_SECTOR_AUS ,APS_AGENT_CD_AUS ,IND_COMMITTEE_BEL ,NACE_CD_BEL FROM PS_DEPT_TBL

# 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_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: HCR_SUP_ID_DVW

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

Prompt Table: POSN_DATA_VW

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 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_DPCD_NW Character(2) VARCHAR2(2) NOT NULL CATS Department Code - New

Prompt Table: HP_STATS_CIP_CD

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

Prompt Table: HP_STATS_FACLTY

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

47 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

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

51 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