DEPT_EFFVW(SQL View) |
Index Back |
|---|---|
Department Tbl EffDt ViewDepartment table effective-date view used for current-date data publishing. |
| SELECT %subrec(DEPT_EFFVW,A) FROM PS_DEPT_TBL A WHERE %EffdtCheck(DEPT_TBL A1, A, %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 3 | EFFDT |
Date(10) | DATE | Effective Date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 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 |
| 8 | SETID_LOCATION | Character(5) | VARCHAR2(5) NOT NULL | Location SetID |
| 9 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 10 | TAX_LOCATION_CD | Character(10) | VARCHAR2(10) NOT NULL | Tax Location Code |
| 11 | MANAGER_ID | Character(11) | VARCHAR2(11) NOT NULL | Manager ID |
| 12 | MANAGER_POSN | Character(8) | VARCHAR2(8) NOT NULL | Manager Position |
| 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 |
| 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 |
| 17 | CAN_IND_SECTOR | Character(3) | VARCHAR2(3) NOT NULL | Canadian Industrial Sector |
| 18 | ACCIDENT_INS | Character(3) | VARCHAR2(3) NOT NULL | Accident Insurance |
| 19 | SI_ACCIDENT_NUM | Character(15) | VARCHAR2(15) NOT NULL | Social Insurance Accident # |
| 20 | HAZARD | Character(4) | VARCHAR2(4) NOT NULL | Hazard |
| 21 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL | Establishment ID |
| 22 | RISKCD | Character(6) | VARCHAR2(6) NOT NULL | Risk Code |
| 23 | GVT_DESCR40 | Character(40) | VARCHAR2(40) NOT NULL | Description |
| 24 | GVT_SUB_AGENCY | Character(2) | VARCHAR2(2) NOT NULL | Sub-Agency |
| 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 | CLASS_UNIT_NZL | Character(5) | VARCHAR2(5) NOT NULL | This field is used in the calculation of ARCI premiums. |
| 34 | 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. |
| 35 | 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) |
| 36 | APS_AGENT_CD_AUS | Number(3,0) | SMALLINT NOT NULL | Australia Public Service (APS) Agency Code. |
| 37 | 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, |
| 38 | 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 |
| 39 | FTE_EDIT_INDC | Character(1) | VARCHAR2(1) NOT NULL |
FTE Edit Indicator
H=Error N=No Edit S=Warning |
| 40 | DEPT_TENURE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Can Grant Tenure |
| 41 | TL_DISTRIB_INFO | Character(1) | VARCHAR2(1) NOT NULL | Use TL Distribution? |
| 42 | USE_BUDGETS | Character(1) | VARCHAR2(1) NOT NULL | Use Budgeting Feature? |
| 43 | USE_ENCUMBRANCES | Character(1) | VARCHAR2(1) NOT NULL | Use Encumbrance Processing? |
| 44 | USE_DISTRIBUTION | Character(1) | VARCHAR2(1) NOT NULL | Use Paycheck Distribution? |
| 45 | BUDGET_DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Budget with Department |
| 46 | DIST_PRORATE_OPTN | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Prorate Option
C=Calendar Days N=Not Applicable W=Work Days |
| 47 | HP_STATS_DEPT_CD | Character(3) | VARCHAR2(3) NOT NULL | Stats Can Dept Code |
| 48 | HP_STATS_FACULTY | Character(5) | VARCHAR2(5) NOT NULL | Faculty Code |
| 49 | MANAGER_NAME | Character(30) | VARCHAR2(30) NOT NULL | Identifies the name of the manager of a specified department. |
| 50 | ACCOUNTING_OWNER | Character(30) | VARCHAR2(30) NOT NULL | Accounting Owner |
| 51 | COUNTRY_GRP | Character(18) | VARCHAR2(18) NOT NULL | Country Group |
| 52 | BUDGETARY_ONLY | Character(1) | VARCHAR2(1) NOT NULL | Budgetary Only |
| 53 | SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle. |
| 54 | SYNCDTTM | DateTime(26) | TIMESTAMP |
Synchronization Last Update Date Time
Default Value: %datetime |