| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
|
| 2 |
RUN_CNTL_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Run Control ID
|
| 3 |
TRN_CHARGEABLE_ORG |
Character(1) |
VARCHAR2(1) NOT NULL |
Chargeable Organization
D=From Enrollment Department
J=From Employee Company Code
|
| 4 |
FROMDATE |
Date(10) |
DATE |
From Date
|
| 5 |
THRUDATE |
Date(10) |
DATE |
End Date
|
| 6 |
ASOFDATE |
Date(10) |
DATE |
As of Date
|
| 7 |
LANGUAGE_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Language Code
|
| 8 |
CALENDAR_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Calendar Year
|
| 9 |
DECL_YR_2483_FRA |
Number(4,0) |
SMALLINT NOT NULL |
French Report 2483 : Declaring Year
Prompt Table:
TRN_2483_PARM
|
| 10 |
SERVICE_YEARS |
Number(2,0) |
SMALLINT NOT NULL |
Years of Service
|
| 11 |
POSITION_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Position Number
Prompt Table:
POSITION_DATA
|
| 12 |
POS_ACTIVE_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Pos Active,Inactive,Both Optn
1=Active
2=Inactive
3=Both Active and Inactive
|
| 13 |
POS_ACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Active Positions
A=Position Active
|
| 14 |
POS_INACTIVE |
Character(1) |
VARCHAR2(1) NOT NULL |
Inactive Positions
I=Position Inactive
|
| 15 |
POS_REPORT_LEVEL |
Number(2,0) |
SMALLINT NOT NULL |
Pos Hierarchy Report Level
|
| 16 |
POS_VACANT_REQUEST |
Character(1) |
VARCHAR2(1) NOT NULL |
Request for Vacant Pos Report
1=Run Vacant Budgeted Positn Rpt
2=Create Requistn for Vacant Pos
|
| 17 |
POS_EXCEPT_OVRRIDE |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Exception Override
E=Exception
O=Override
|
| 18 |
JOB_REQ_NBR |
Character(6) |
VARCHAR2(6) NOT NULL |
Job requisition number
|
| 19 |
JOBCODE |
Character(6) |
VARCHAR2(6) NOT NULL |
Job Code
Prompt Table:
JOBCODE_TBL
|
| 20 |
DEPTID |
Character(10) |
VARCHAR2(10) NOT NULL |
Department
Prompt Table:
DEPARTMENT_SRCH
|
| 21 |
REPORT_CHOICE |
Character(1) |
VARCHAR2(1) NOT NULL |
Output Report Choice
1=Applicants
2=Current Employees
3=Both Applicants and Employees
|
| 22 |
POPULATION |
Character(1) |
VARCHAR2(1) NOT NULL |
Search Population-Skill Match
1=All
2=Internal Applicants
3=External Applicants
4=Candidates for Specific Positn
|
| 23 |
EE_REPORT_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Empl Equity Reporting Year
|
| 24 |
BUDGET_START_DT |
Date(10) |
DATE |
Budget Start Date
Prompt Table:
RUN_BUDGET1_VW
|
| 25 |
SAL_ADMIN_PLAN |
Character(4) |
VARCHAR2(4) NOT NULL |
Salary Administration Plan
Prompt Table:
SAL_PLAN_TBL
Set Control Field: SETID
|
| 26 |
INCR_START_DT |
Date(10) |
DATE |
Start Date for Step Increments
|
| 27 |
INCR_END_DT |
Date(10) |
DATE |
End Date for Step Increments
|
| 28 |
JOB_EFFDT |
Date(10) |
DATE |
Job Effective Date
|
| 29 |
COMPANY |
Character(3) |
VARCHAR2(3) NOT NULL |
Company
Prompt Table:
COMPANY_TBL
|
| 30 |
PAYGROUP |
Character(3) |
VARCHAR2(3) NOT NULL |
Pay Group
Prompt Table:
PAYGROUP_TBL
|
| 31 |
PERCENTCHG |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Calculation Percent
|
| 32 |
AMOUNTCHG |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Amount of Salary Change
|
| 33 |
EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table:
PERALL_SEC_SRCH
|
| 34 |
INCIDENT_NBR |
Character(8) |
VARCHAR2(8) NOT NULL |
Incident Number
Prompt Table:
INCIDENT_DATA
|
| 35 |
CAN_OEE_AREACD |
Character(2) |
VARCHAR2(2) NOT NULL |
CEC Management Area
01=Toronto Management Area
02=Hamilton Management Area
03=Niagra Management Area
04=Brant Haldimand, Norfolk Area
05=Windsor Management Area
06=London Management Area
07=Kitchener Management Area
08=Mississauga Management Area
09=Brampton Management Area
10=York Management Area
11=Georgian Bay Management Area
12=Kenora Management Area
13=Timmins Management Area
14=Slt.St.Marie Management Area
15=Sudbury Management Area
16=North Bay Management Area
17=Pembroke Management Area
18=Ottawa Management Area
19=Cornwall Management Area
20=Kingston Management Area
21=Belleville Management Area
22=Peterborough Management Area
23=Oshawa Management Area
Default Value: 01
|
| 36 |
COURSE |
Character(6) |
VARCHAR2(6) NOT NULL |
Course Code
Prompt Table:
COURSE_TBL
|
| 37 |
SESSION_NBR |
Character(4) |
VARCHAR2(4) NOT NULL |
Course Session Nbr
Prompt Table:
CRSE_ALL_SSN_VW
|
| 38 |
COURSE_START_DT |
Date(10) |
DATE |
Course Start Date
|
| 39 |
FACILITY |
Character(6) |
VARCHAR2(6) NOT NULL |
Facility
Prompt Table:
TRN_FACIL_TBL
|
| 40 |
AD_SALADMIN_PLN |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Salary Admin Plan
Y/N Table Edit
|
| 41 |
AD_GRADE |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Grade
N=Report Only
Y=Report & Process Increases
|
| 42 |
AD_GRADE_ENTRY_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Grade Entry Date
Y/N Table Edit
|
| 43 |
AD_STEP |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Step
Y/N Table Edit
|
| 44 |
AD_STEP_ENTRY_DT |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Step Entry Date
Y/N Table Edit
|
| 45 |
AD_COMPRATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Comprate
Y/N Table Edit
|
| 46 |
AD_HOURLYRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Hourly Rate
Y/N Table Edit
|
| 47 |
AD_MONTHLYRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Monthly Rate
Y/N Table Edit
|
| 48 |
AD_ANNUALRT |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Annual Rate
Y/N Table Edit
|
| 49 |
AD_CHANGEAMT |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Change Amount
Y/N Table Edit
|
| 50 |
AD_CHANGEPCT |
Character(1) |
VARCHAR2(1) NOT NULL |
Audit Change Percentage
Y/N Table Edit
|
| 51 |
EEO_REPORT_TYPE |
Character(4) |
VARCHAR2(4) NOT NULL |
EEO Report Run Type
GOVT=Govt. Report Run
INFO=Informational Report Run
|
| 52 |
PER_UNIT_COST |
Number(19,3) |
DECIMAL(18,3) NOT NULL |
Per Unit Cost
|
| 53 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY
Prompt Table:
CURRENCY_CD_TBL
|
| 54 |
COST_UNIT_CD |
Character(10) |
VARCHAR2(10) NOT NULL |
Cost Unit
Default Value: STUD/D
Prompt Table:
PR_COST_UNIT_VW
|
| 55 |
APPLY_SALARY_COST |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Training Cost
D=Defaulting from Jobcodes
E=Apply on Employees
G=Load from Global Payroll
J=Apply on Jobcodes
Default Value: J
|
| 56 |
BUDGET_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget Period
Prompt Table:
BUDGET_PERIOD
|
| 57 |
DEMAND_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Demand Priority
1=High
2=Medium
3=Low
Default Value: 2
|
| 58 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 59 |
BASE_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
Base Currency
|
| 60 |
ATTENDANCE_IN |
Character(23) |
VARCHAR2(23) NOT NULL |
Attendance In
|
| 61 |
SCENARIO |
Character(10) |
VARCHAR2(10) NOT NULL |
Scenario
Prompt Table:
TRN_GBL_SCE_VW
|
| 62 |
NEW_SCENARIO |
Character(10) |
VARCHAR2(10) NOT NULL |
New Scenario
|
| 63 |
ACTIVE_NEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Active New Scenario
Y/N Table Edit
Default Value: N
|
| 64 |
SCENARIO_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Scenario Type
A=Active Scenario
G=Global Scenario
|
| 65 |
APPROVED_FACTOR |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
Increase Approved by Factor
|
| 66 |
APPROVE_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Higher than Priority
1=High Priority
2=Medium Priority
3=Low Priority
Default Value: 2
|
| 67 |
UNAPPROVE_PRIORITY |
Character(1) |
VARCHAR2(1) NOT NULL |
Less than Priority
1=High Priority
2=Medium Priority
3=Low Priority
Default Value: 2
|
| 68 |
IND_DMND_CNTRL_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Individual Demand Control
A=Approve
D=Unapprove
N=All Demands
Default Value: N
|
| 69 |
YEAR_NBR |
Number(1,0) |
SMALLINT NOT NULL |
Years Number
|
| 70 |
GROUP_SHEET_ID_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Indicator Group
Prompt Table:
GROUP_SHEET_FRA
|
| 71 |
INDICATR_SHEET_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Indicator
Prompt Table:
INDIC_SHEET_FRA
|
| 72 |
ESTABID |
Character(12) |
VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table:
ESTAB_TBL
|
| 73 |
FROM_CLAUSE |
Character(253) |
VARCHAR2(253) NOT NULL |
Scenario From Clause
|
| 74 |
WHERE_CLAUSE |
Long Character(500) |
VARCHAR2(500) |
Where Clause
|
| 75 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_HR.BUSINESS_UNIT
Prompt Table:
BUS_UNIT_TBL_HR
|
| 76 |
BUDGET_BUS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
BUDGET_BUS_UNIT
|
| 77 |
SETID |
Character(5) |
VARCHAR2(5) NOT NULL |
SetID
Prompt Table:
SETID_TBL
|
| 78 |
FZN_BUDGET_BUSUNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table:
TRN_FZN_BGT_BU
|
| 79 |
TRGT_BUDGET_PERIOD |
Character(10) |
VARCHAR2(10) NOT NULL |
Target Budget Period
Prompt Table:
TRN_NFZNBDGT_VW
|
| 80 |
ACTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Action
Prompt Table:
ACTION_TBL
|
| 81 |
ACTION_REASON |
Character(3) |
VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table:
ACTN_REASON_TBL
|
| 82 |
NO_REVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Required
|
| 83 |
GROUP_SHEET_CD_FRA |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator Group
Prompt Table:
GROUP_SHEET_FRA
|
| 84 |
INDIC_SHEET_CD_FRA |
Character(5) |
VARCHAR2(5) NOT NULL |
Indicator
Prompt Table:
INDIC_SHEET_FRA
|
| 85 |
CREATION_DT |
Date(10) |
DATE |
Creation Date
Default Value: %DATE
|
| 86 |
PURGE_BASED_ON |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Based On
A=Application Date
P=Application Purge Date
Default Value: P
|
| 87 |
PURGE_PRCS_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Purge Process Option
1=Print and Process
2=Process Only
3=Print Only
Default Value: 3
|
| 88 |
RATE_CODE_GROUP |
Character(6) |
VARCHAR2(6) NOT NULL |
Rate Code Group Name
Prompt Table:
COMPRT_GRP_TBL
|
| 89 |
COMP_RATECD |
Character(6) |
VARCHAR2(6) NOT NULL |
Comp Rate Code
Prompt Table:
BASE_RATECD_VW
|
| 90 |
WC_COUNCIL_ID |
Character(9) |
VARCHAR2(9) NOT NULL |
Works Council ID
Prompt Table:
WC_COUNCIL_TBL
|
| 91 |
MC_DEFN_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Mass Change Definition
|
| 92 |
JOB_EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Job Effective Sequence
|
| 93 |
COMP_CHG_AMT |
Signed Number(20,6) |
DECIMAL(18,6) NOT NULL |
Change Amount
|
| 94 |
COMP_CHG_PCT |
Signed Number(8,3) |
DECIMAL(6,3) NOT NULL |
Change Percent
|
| 95 |
COMP_COMPRATE |
Number(19,6) |
DECIMAL(18,6) NOT NULL |
Compensation Rate
|
| 96 |
AE_APPL_ID |
Character(8) |
VARCHAR2(8) NOT NULL |
Application
|
| 97 |
OVERRIDE_IND |
Character(1) |
VARCHAR2(1) NOT NULL |
Override Indicator
Y/N Table Edit
Default Value: N
|
| 98 |
DEC2483_YEAR |
Date(10) |
DATE |
DEC2483 Year
|
| 99 |
GRADE |
Character(3) |
VARCHAR2(3) NOT NULL |
Salary Grade
Prompt Table:
SAL_GRADE_TBL
Set Control Field: SETID
|
| 100 |
SINGLE_CHECK |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple State Employer
Y/N Table Edit
Default Value: N
|
| 101 |
STATE_NUMBER |
Character(2) |
VARCHAR2(2) NOT NULL |
State Number
|
| 102 |
GB_GROUP_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table:
GB_GROUP_SEC_VW
|
| 103 |
GB_EFFDT |
Date(10) |
DATE |
Group As Of Date
|
| 104 |
GB_REFINE_DATE |
Date(10) |
DATE |
Refinement Date
|
| 105 |
REG_REGION |
Character(5) |
VARCHAR2(5) NOT NULL |
Regulatory Region
Prompt Table:
REG_REGION_TBL
|
| 106 |
BUDGET_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Budget ID
Prompt Table:
BUDGET_COMP1_VW
|
| 107 |
MULT_COMP_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Multiple Company Field
Y/N Table Edit
Default Value: N
|
| 108 |
REVIEW_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Review Type
A=Self Assesssment
B=Both
E=Employee Feedback
I=Initial Rating
M=Interim Rating
O=Official Rating
P=Performance
R=Adjustment Result
S=Salary
|
| 109 |
PROCESS_BY |
Character(1) |
VARCHAR2(1) NOT NULL |
Used by the RUNCTL_SENPAY run control panel.
A=All
G=Group ID
J=Jobcode
L=Sal Admin Plan
P=Paygroup
R=Rate Code
S=Sal Plan/Grade
Default Value: R
|
| 110 |
INSTRUCTOR_ID |
Character(11) |
VARCHAR2(11) NOT NULL |
Instructor ID
Prompt Table:
TRN_INSTRCT_VW
|
| 111 |
VERSIONGBQDM |
Number(10,0) |
DECIMAL(10) NOT NULL |
Version Number
|
| 112 |
INTERNAL_EXTERNAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Internal/External
E=External
I=Internal
|
| 113 |
PER_ORG |
Character(3) |
VARCHAR2(3) NOT NULL |
Defines the Organizational Relationship(s) that a Person has to the Organization. These are Employee, Contingent Worker, and Persons of Interest.
CWR=Contingent Worker
EMP=Employee
POI=Person of Interest
|
| 114 |
OPRCLASS |
Character(30) |
VARCHAR2(30) NOT NULL |
Operator Class
Prompt Table:
OPRDEFN_SCRTY4
|
| 115 |
DEGREE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Degree Detail
N=No
Y=Yes
|
| 116 |
LICENSE_CERTIF_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
License/Certification Detail
N=No
Y=Yes
|
| 117 |
TRAINING_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Training Type
A=Administer Training
B=Budget Training
Default Value: A
|
| 118 |
TYPE_SHEET_CD_FRA |
Character(2) |
VARCHAR2(2) NOT NULL |
Used to regroup Employee Survey groups of indicators, based on legal requirement.
CT=Trade & Services Company
ET=Trade & Services Establishment
|
| 119 |
PIN_NUM |
Number(8,0) |
INTEGER NOT NULL |
PIN Number
Prompt Table:
%GP_EDIT_FLD1
|
| 120 |
EMP_LIST_CRITERIA |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee Listing Criteria
D=Department
I=Employee Id
N=Employee Name
|
| 121 |
DETYA_REP_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to identify the type of reporting being generated for DETYA purposes.
C=Casual Staff
S=Permanent Employee
Default Value: S
|
| 122 |
ACCOMPLISHMENT |
Character(8) |
VARCHAR2(8) NOT NULL |
Accomplishment
Prompt Table:
LIC_CERTIF_VW
|
| 123 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Record
|
| 124 |
FP_EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee or Spouse ID
Prompt Table:
%RECNAME_EDIT
|
| 125 |
FP_CORPS_CD |
Character(6) |
VARCHAR2(6) NOT NULL |
Corps
Prompt Table:
FPMCORPS_TBL
|
| 126 |
FP_STATUSEE_CD |
Character(1) |
VARCHAR2(1) NOT NULL |
Employee status
|
| 127 |
FP_HYP_NBR |
Number(3,0) |
SMALLINT NOT NULL |
Assumption Nbr
|
| 128 |
FP_YES_NO |
Character(1) |
VARCHAR2(1) NOT NULL |
YES/NO Fields
Y/N Table Edit
|
| 129 |
FP_CHG_SAL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forced Salary
|
| 130 |
FP_ORIG |
Character(1) |
VARCHAR2(1) NOT NULL |
Row Origin
A=Order Abrogation
C=Collective Orders
I=Individual Orders (Single)
J=Individual Orders (Mass)
R=Retroactivity Abrogation
|
| 131 |
FP_EDT_TMP |
Character(1) |
VARCHAR2(1) NOT NULL |
Provisional Editing
|
| 132 |
FP_EDT_FNL |
Character(1) |
VARCHAR2(1) NOT NULL |
Final Editing
|
| 133 |
FP_COLDEC_NBR |
Character(12) |
VARCHAR2(12) NOT NULL |
Collective Order Nbr
|
| 134 |
FP_REFCOL_PS |
Number(8,0) |
INTEGER NOT NULL |
PSoft Ref Collective Order
|
| 135 |
FP_NOTIF_REF |
Character(8) |
VARCHAR2(8) NOT NULL |
Order reference
|
| 136 |
FP_CONVERSION_ID |
Character(20) |
VARCHAR2(20) NOT NULL |
Reclassification ID
Prompt Table:
FPMCONVTABL0_TB
|
| 137 |
FP_ADM_APPL_DT |
Date(10) |
DATE |
Application Admin Date
|
| 138 |
FP_CONV_EFFDT |
Date(10) |
DATE |
Conversion Effective Date
Prompt Table:
FPMCONVTABL_VW1
|
| 139 |
FP_FROMDATE_CHECK |
Date(10) |
DATE |
Checking Start Date
|
| 140 |
FP_RATING_PRS |
Number(3,0) |
SMALLINT NOT NULL |
Rating Attendance
|
| 141 |
FP_THRUDATE |
Date(10) |
DATE |
Starting Date
Prompt Table:
FPMPROMTABL_VW
|
| 142 |
FP_RANK_START |
Character(6) |
VARCHAR2(6) NOT NULL |
Grade of Origin
Prompt Table:
FPMPROMTAB02_VW
|
| 143 |
FP_SETID_RANK |
Character(5) |
VARCHAR2(5) NOT NULL |
Set ID
Prompt Table:
FPMPROMTAB01_VW
|
| 144 |
FP_CA_CATG_ID |
Character(6) |
VARCHAR2(6) NOT NULL |
CAE Category
Prompt Table:
FPM_CA_CTG_TBL
|
| 145 |
FP_STFBDG_LVL1 |
Character(2) |
VARCHAR2(2) NOT NULL |
Section
EM=Labor
LG=Housing
S1=Sector 1
S2=Sector 2
SL=Solidarity
TO=Tourism
TR=Transportation
|
| 146 |
FP_FINANC_LAW_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Finance Act
Prompt Table:
FPM_CA_FINLAW
|
| 147 |
UPD_FUTURE_ROW_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Future Rows
N=No
Y=Yes
Y/N Table Edit
|
| 148 |
CREATE_GROUP |
Character(1) |
VARCHAR2(1) NOT NULL |
Populate Group
Y/N Table Edit
|
| 149 |
APS_REP_TYPE_AUS |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is required to identify the type of APS Report being generated.
C=Change Extract
S=Snapshot Report
Default Value: S
|
| 150 |
PHONE |
Character(24) |
VARCHAR2(24) NOT NULL |
Telephone
|
| 151 |
CMP_DONT_ABSORB |
Character(1) |
VARCHAR2(1) NOT NULL |
Don't Absorb Changes
N=No
Y=Yes
Y/N Table Edit
|
| 152 |
POSITION_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Position Flag
N=No
Y=Yes
Y/N Table Edit
|
| 153 |
SP_PROCESS_NAME |
Character(12) |
VARCHAR2(12) NOT NULL |
Process Name
|
| 154 |
PRCS_MODE_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Update Process updates or adds values according to this flag.
I=Add new effective date
U=Correction on current Info.
Default Value: I
|
| 155 |
USER_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
User ID
Prompt Table:
PSOPRDEFN_SRCH
|
| 156 |
LOCK_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
Create Users as locked
Y/N Table Edit
|
| 157 |
URL |
Character(254) |
VARCHAR2(254) NOT NULL |
Internet URL (Universal Resource Locator)
|
| 158 |
FISCAL_YR_FRA |
Number(4,0) |
SMALLINT NOT NULL |
This field is used for initializing profit sharing dates
|
| 159 |
PAID_HOURS |
Number(7,2) |
DECIMAL(6,2) NOT NULL |
Paid Hours
|
| 160 |
GP_PAYGROUP |
Character(10) |
VARCHAR2(10) NOT NULL |
Global Payroll pay group
Prompt Table:
GP_PYGRP
|
| 161 |
PRD_BGN_DT |
Date(10) |
DATE |
Period Begin Date
|
| 162 |
PRD_END_DT |
Date(10) |
DATE |
Pay Period End Date
|
| 163 |
TRN_FTGROSS_WA_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
French Report 2483 : Training Gross WA Field
Default Value: TRN_FT_GROSS_AMT
Prompt Table:
TRN2483_WAFLDVW
|
| 164 |
TRN_GROSS_WA_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Gross Salary WA Field
Default Value: GROSS_AMT
Prompt Table:
TRN2483_WAFLDVW
|
| 165 |
TRN_PAID_HR_WA_FLD |
Character(18) |
VARCHAR2(18) NOT NULL |
Paid Hours WA Field
Default Value: PAID_HOURS
Prompt Table:
TRN2483_WAFLDVW
|
| 166 |
TRN_DATE_SELECTION |
Character(1) |
VARCHAR2(1) NOT NULL |
French Report 2483 : Select by
E=Period End Date
P=Payment Date
|
| 167 |
TRN_EXT_EXPNS_TBL |
Character(15) |
VARCHAR2(15) NOT NULL |
French Report 2483 : External Expense record
Prompt Table:
RECDEFN_VW
|
| 168 |
TRN_PLN_CAT_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Flag for Training Plan Category
0=Training Plan Category
1=Scenario
Default Value: 1
|
| 169 |
TRN_PLN_CATEGORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Feild for Training Plan Category
0=Not Specified
1=Adaptation to Job Changement
2=Job Preservation
3=Skill Development
Default Value: 0
|
| 170 |
STRM_NUM |
Number(4,0) |
SMALLINT NOT NULL |
Stream Number
Default Value: 1
|
| 171 |
FILENAME |
Character(80) |
VARCHAR2(80) NOT NULL |
File Name
|
| 172 |
STATE |
Character(6) |
VARCHAR2(6) NOT NULL |
State
Prompt Table:
HR_RFWSTATE_VW
|