R_PER507(SQL Table) |
Index Back |
---|---|
Temp tbl for PER507Used 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
|
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 |