R_PER507

(SQL Table)
Index Back

Temp tbl for PER507

Used to load Department Tree and DeptTbl from external sources. Used in the sqrs PER507, PER508, PER509 Keep in Sync with DEPT_TBL - with the addition of the tree fields at the bottom.

# 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 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_DPCD_NW Character(2) VARCHAR2(2) NOT NULL CATS Department Code - New
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
52 SETID_RPDEPT Character(5) VARCHAR2(5) NOT NULL SETID
53 REPORTS_TO_DEPT Character(10) VARCHAR2(10) NOT NULL Reports To Department
54 ORGCODE Character(60) VARCHAR2(60) NOT NULL Organization Hierarchy Code
55 ORGCODE_FLAG Character(1) VARCHAR2(1) NOT NULL Organization Hierarchy Flag
56 TREE_EFFDT Date(10) DATE Effective date of the Tree
57 TREE_LEVEL_NUM Number(3,0) SMALLINT NOT NULL Parent tree level if this is a part of the PSTREEBRANCH record
58 PARENT_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Parent Node Number
59 TREE_NODE_NUM Number(10,0) DECIMAL(10) NOT NULL Internal beginning node range number
60 TREE_NODE_NUM_END Number(10,0) DECIMAL(10) NOT NULL Internal ending node range number
61 CAN_NAICS_CD Number(4,0) SMALLINT NOT NULL Canadian NAICS Code