INSTALLATION(SQL Table) |
Index Back |
|---|---|
Site-Specific Install OptionsUse the INSTALLATION record to set parameters for running your PeopleSoft system at your specific site. For example, if you are running PeopleSoft on a DB2 machine, you enter certain parameters here. If you use auto-numbering in PeopleSoft, such as auto-assignment of employee IDs, you enter the beginning sequence number here. If you run PeopleSoft Payroll, you specify the number of payroll records to be run before a 'Commit' is executed. If you are running Position Management, you specify whether you are running partial or full Position Management. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 2 | MIN_STD_HRS | Number(7,2) | DECIMAL(6,2) NOT NULL | Minimum Standard Hours |
| 3 | MAX_STD_HRS | Number(7,2) | DECIMAL(6,2) NOT NULL | Maximum Standard Hours |
| 4 | EMPLID_LENGTH | Number(2,0) | SMALLINT NOT NULL |
EMPLID Field Length
Default Value: 4 |
| 5 | STD_HRS_DEFAULT | Number(7,2) | DECIMAL(6,2) NOT NULL |
Default Standard Hours
Default Value: 40 |
| 6 | STD_HRS_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Standard Work Period
Default Value: W Prompt Table: STDHRS_FREQ_VW |
| 7 | TEMP_SSN_MASK | Character(3) | VARCHAR2(3) NOT NULL |
'Temporary SSN' Mask
Default Value: 999 |
| 8 | COMMIT_AFTER | Number(4,0) | SMALLINT NOT NULL |
Commit After Empl Processed
Default Value: 300 |
| 9 | POSITION_MGMT | Character(1) | VARCHAR2(1) NOT NULL |
Position Management Option
F=Full Position Management N=No Position Management P=Partial Position Management Default Value: N |
| 10 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL |
Country
Prompt Table: COUNTRY_TBL |
| 11 | COMP_FREQUENCY | Character(5) | VARCHAR2(5) NOT NULL |
Compensation Frequency
A=Annual B=Biweekly C=Contract D=Daily H=Hourly M=Monthly S=Semimonthly W=Weekly Default Value: M Prompt Table: COMP_FREQ_VW |
| 12 | EMPLID_LAST_EMPL | Number(10,0) | DECIMAL(10) NOT NULL | Last Employee ID Assigned |
| 13 | NON_EMPLOYEE_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last H&S Non-Employee ID Assgn |
| 14 | DEMAND_ID_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last Demand ID Assigned |
| 15 | POSN_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last Position Number Assigned |
| 16 | GRIEVANCE_NBR_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last Grievance Number Assigned |
| 17 | INCIDENT_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last Incident # Assignend |
| 18 | CLAIM_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last H/S Claim # Assigned |
| 19 | FILE_CREATE_LAST | Number(4,0) | SMALLINT NOT NULL | Last Dir Dep File Creation # |
| 20 | ROE_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last ROE # Used (Canadian) |
| 21 | CAN_CMA | Character(2) | VARCHAR2(2) NOT NULL |
Canadian Census Metropol Area
Default Value: 06 |
| 22 | CAN_IND_SECTOR | Character(3) | VARCHAR2(3) NOT NULL |
Canadian Industrial Sector
Default Value: 451 |
| 23 | MULTI_STEP_GRADE | Character(1) | VARCHAR2(1) NOT NULL |
Multi-Step Grade
Y/N Table Edit Default Value: N |
| 24 | FSA_CLAIMS | Character(1) | VARCHAR2(1) NOT NULL |
FSA Claims Administration
Y/N Table Edit Default Value: N |
| 25 | BENEFIT_ADMINISTRN | Character(1) | VARCHAR2(1) NOT NULL |
Benefits Administration
Y/N Table Edit Default Value: N |
| 26 | START_EVENT_DT | Date(10) | DATE | Start Date for BenAdmin |
| 27 | EXCHNG_TO_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
To Currency
Default Value: USD Prompt Table: CURRENCY_CD_TBL |
| 28 | EXCHNG_TO_RT_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Currency Rate Type
Default Value: OFFIC Prompt Table: RT_TYPE_TBL |
| 29 | HR | Character(1) | VARCHAR2(1) NOT NULL |
Human Resources
Y/N Table Edit Default Value: Y |
| 30 | AM | Character(1) | VARCHAR2(1) NOT NULL |
Asset Management
Y/N Table Edit Default Value: N |
| 31 | AP | Character(1) | VARCHAR2(1) NOT NULL |
Payables
Y/N Table Edit Default Value: N |
| 32 | AR | Character(1) | VARCHAR2(1) NOT NULL |
Receivables
Y/N Table Edit Default Value: N |
| 33 | GL | Character(1) | VARCHAR2(1) NOT NULL |
General Ledger
Y/N Table Edit Default Value: N |
| 34 | BD | Character(1) | VARCHAR2(1) NOT NULL |
Budgets
Y/N Table Edit Default Value: N |
| 35 | PC | Character(1) | VARCHAR2(1) NOT NULL |
Project Costing
Y/N Table Edit Default Value: N |
| 36 | PO | Character(1) | VARCHAR2(1) NOT NULL |
Purchase Order
Y/N Table Edit Default Value: N |
| 37 | INV | Character(1) | VARCHAR2(1) NOT NULL |
Inventory
Y/N Table Edit Default Value: N |
| 38 | BI | Character(1) | VARCHAR2(1) NOT NULL |
Billing
Y/N Table Edit Default Value: N |
| 39 | OM | Character(1) | VARCHAR2(1) NOT NULL |
Order Management
Y/N Table Edit Default Value: N |
| 40 | PUBLIC_SECTOR | Character(1) | VARCHAR2(1) NOT NULL |
Education and Government
Y/N Table Edit Default Value: N |
| 41 | RETROPAY_SEQ_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Retropay Request # |
| 42 | RETRODED_SEQ_LAST | Number(9,0) | DECIMAL(9) NOT NULL | Last Retroded Request Seq. No. |
| 43 | RETRO_DEDUCTIONS | Character(1) | VARCHAR2(1) NOT NULL |
Retroactive Deductions
Y/N Table Edit Default Value: Y |
| 44 | TL | Character(1) | VARCHAR2(1) NOT NULL |
PS/Time and Labor Product
Y/N Table Edit Default Value: N |
| 45 | AUTO_EE_TAX | Character(1) | VARCHAR2(1) NOT NULL |
Automatic Employee Tax Data
Y/N Table Edit Default Value: Y |
| 46 | SAME_ST_LCL_RSDNCE | Character(1) | VARCHAR2(1) NOT NULL |
Use State Residence for Local
Y/N Table Edit Default Value: Y |
| 47 | FMLA_ADMINISTRN | Character(1) | VARCHAR2(1) NOT NULL |
FMLA Administration
Y/N Table Edit Default Value: N |
| 48 | BAL_ID_FOR_CAL_YR | Character(2) | VARCHAR2(2) NOT NULL |
Balance ID for Calendar Year
Default Value: CY |
| 49 | MAX_ROWS_SCROLL | Number(5,0) | INTEGER NOT NULL |
Max Number of Rows in Scrolls
Default Value: 25 |
| 50 | PA | Character(1) | VARCHAR2(1) NOT NULL |
PS/Pension Administration
Y/N Table Edit Default Value: N |
| 51 | CAR_LAST | Number(7,0) | INTEGER NOT NULL | Last Car # Assigned |
| 52 | BEN_BILLING | Character(1) | VARCHAR2(1) NOT NULL |
Benefits Billing
Y/N Table Edit Default Value: N |
| 53 | COBRA_ADMINISTRN | Character(1) | VARCHAR2(1) NOT NULL |
COBRA Administration
Y/N Table Edit Default Value: N |
| 54 | LAST_TL_CONTRCTR | Number(10,0) | DECIMAL(10) NOT NULL | Last TL Contractor ID Assigned |
| 55 | ORGCHART | Character(1) | VARCHAR2(1) NOT NULL |
Organization Chart
N=None O=Other V=Visio Default Value: N |
| 56 | COBRA_EMPLID_LAST | Number(10,0) | DECIMAL(10) NOT NULL | Last COBRA Emplid Assigned |
| 57 | FSA_CLAIM_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last FSA Claim # Assigned |
| 58 | FSA_CRY_CLAIM_LAST | Number(8,0) | INTEGER NOT NULL | Last FSA CarryForward Claim # |
| 59 | US | Character(1) | VARCHAR2(1) NOT NULL |
USA - United States
Y/N Table Edit Default Value: N |
| 60 | CAN | Character(1) | VARCHAR2(1) NOT NULL |
CAN - Canada
Y/N Table Edit Default Value: N |
| 61 | GER | Character(1) | VARCHAR2(1) NOT NULL |
DEU - Germany
Y/N Table Edit Default Value: N |
| 62 | FRA | Character(1) | VARCHAR2(1) NOT NULL |
FRA - France
Y/N Table Edit Default Value: N |
| 63 | UK | Character(1) | VARCHAR2(1) NOT NULL |
GBR - United Kingdom
Y/N Table Edit Default Value: N |
| 64 | JPN | Character(1) | VARCHAR2(1) NOT NULL |
JPN - Japan
Y/N Table Edit Default Value: N |
| 65 | BEL | Character(1) | VARCHAR2(1) NOT NULL |
BEL - Belgium
Y/N Table Edit Default Value: N |
| 66 | NLD | Character(1) | VARCHAR2(1) NOT NULL |
NLD - Netherlands
Y/N Table Edit Default Value: N |
| 67 | ESP | Character(1) | VARCHAR2(1) NOT NULL |
ESP - Spain
Y/N Table Edit Default Value: N |
| 68 | MEX | Character(1) | VARCHAR2(1) NOT NULL |
Field for Country Mexico
Y/N Table Edit Default Value: N |
| 69 | AUS | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Australian Functionality in HRMS
Y/N Table Edit Default Value: N |
| 70 | MYS | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Malaysian Functionality in HRMS
Y/N Table Edit Default Value: N |
| 71 | NZL | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the New Zealand Functionality in HRMS
Y/N Table Edit Default Value: N |
| 72 | SGP | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Singapore Functionality in HRMS
Y/N Table Edit Default Value: N |
| 73 | HKG | Character(1) | VARCHAR2(1) NOT NULL |
HKG - Hong Kong
Y/N Table Edit Default Value: N |
| 74 | INSTALLED_PAY_GBL | Character(1) | VARCHAR2(1) NOT NULL |
Global Payroll Core
Y/N Table Edit Default Value: N |
| 75 | IND | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Indian Functionality in HRMS
Y/N Table Edit Default Value: N |
| 76 | BRA | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Brazilian Functionality in HRMS
Y/N Table Edit Default Value: N |
| 77 | CHN | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Chinese Functionality in HRMS
Y/N Table Edit Default Value: N |
| 78 | THA | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Thailand CE Functionality in HRMS
Y/N Table Edit Default Value: N |
| 79 | INSTALLED_PAY_NA | Character(1) | VARCHAR2(1) NOT NULL |
Payroll for North America
Y/N Table Edit Default Value: N |
| 80 | INSTALLED_PAY_INT | Character(1) | VARCHAR2(1) NOT NULL |
Payroll Interface
Y/N Table Edit Default Value: N |
| 81 | USE_POINTS_SW | Character(1) | VARCHAR2(1) NOT NULL |
Salary Points
Y/N Table Edit Default Value: N |
| 82 | USE_RTCD_GROUP_SW | Character(1) | VARCHAR2(1) NOT NULL |
Use Rate Code Groups
Y/N Table Edit Default Value: N |
| 83 | ROWSECCLASS | Character(30) | VARCHAR2(30) NOT NULL |
The class used to determine row level security
Prompt Table: OPRDEFN_SCRTY |
| 84 | ILL_NBR_LAST_GER | Number(8,0) | INTEGER NOT NULL | Last Illness # Assigned |
| 85 | FED | Character(1) | VARCHAR2(1) NOT NULL |
Federal Functionality
Y/N Table Edit Default Value: N |
| 86 | FP_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
French Public Sector
Y/N Table Edit Default Value: N |
| 87 | GVT_PAY_BASIS | Character(2) | VARCHAR2(2) NOT NULL |
Pay Basis
BW=Bi-weekly FB=Fee Basis PA=Per Annum PD=Per Diem PH=Per Hour PM=Per Month PW=Piece Work SM=Semi-monthly SY=School Year WC=Without Compensation Default Value: PA |
| 88 | ACCT_CD_LAST | Number(18,0) | DECIMAL(18) NOT NULL | Last Account Cd Assigned |
| 89 | CPS_TRANS_ID_LAST | Number(8,0) | INTEGER NOT NULL | Last CPS Transmission ID # |
| 90 | CHE | Character(1) | VARCHAR2(1) NOT NULL |
Switzerland Country field.
Y/N Table Edit Default Value: N |
| 91 | ITA | Character(1) | VARCHAR2(1) NOT NULL |
Italian HR Functionality/
Person name/
Name
Y/N Table Edit Default Value: N |
| 92 | ALLW_CONC_CALCCONF | Character(1) | VARCHAR2(1) NOT NULL |
Concurrent Calc/Confirm
Y/N Table Edit Default Value: N |
| 93 | PIN_NUM_LAST | Number(8,0) | INTEGER NOT NULL |
Last Used Element Number
Default Value: 100000 |
| 94 | GP_CST_INSTALL_IND | Character(1) | VARCHAR2(1) NOT NULL |
Global Payroll Customer Installation Indicator
Y/N Table Edit Default Value: Y |
| 95 | AP_INVNO_PREFIX | Character(1) | VARCHAR2(1) NOT NULL |
AP Invoice Number Prefix
Default Value: P |
| 96 | AP_INVNO_LAST | Number(7,0) | INTEGER NOT NULL | Last AP Invoice Number |
| 97 | ST | Character(1) | VARCHAR2(1) NOT NULL |
PS/Stock Administration
Y/N Table Edit Default Value: N |
| 98 | ILL_NBR_LAST_NLD | Number(5,0) | INTEGER NOT NULL | Last Illness Report # Assigned |
| 99 | ADJ_TL_FINAL_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Change Final Check
Y/N Table Edit Default Value: N |
| 100 | ADJ_TL_ONL_CHK | Character(1) | VARCHAR2(1) NOT NULL |
Change Online Check
Y/N Table Edit Default Value: N |
| 101 | ADJ_TL_REV_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
Change Reversal Adjustments
Y/N Table Edit Default Value: N |
| 102 | REFRSH_TL_JOB_CHG | Character(1) | VARCHAR2(1) NOT NULL |
Refresh on Job Change
Y/N Table Edit Default Value: N |
| 103 | REFRSH_TL_PRECALC | Character(1) | VARCHAR2(1) NOT NULL |
Load in Preliminary Calc
Y/N Table Edit Default Value: N |
| 104 | PSEBENEFITS | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft eBenefits
Y/N Table Edit Default Value: N |
| 105 | PSECOMP | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft eCompensation
Y/N Table Edit Default Value: N |
| 106 | PSEPAY | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft ePay
Y/N Table Edit Default Value: N |
| 107 | PSEPROFILE | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft eProfile
Y/N Table Edit Default Value: N |
| 108 | PSERECRUIT | Character(1) | VARCHAR2(1) NOT NULL |
Candidate Gateway
Y/N Table Edit Default Value: N |
| 109 | CCU | Character(1) | VARCHAR2(1) NOT NULL |
Currency Conversion Utility
Y/N Table Edit Default Value: N |
| 110 | PSEA | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft eDevelopment
Y/N Table Edit Default Value: N |
| 111 | INSTALLED_GP_AUS | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Australia
Y/N Table Edit Default Value: N |
| 112 | INSTALLED_GP_BRA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Brazil
Y/N Table Edit Default Value: N |
| 113 | INSTALLED_GP_CAN | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Canada.
(Reserved field for possible future country extension development).
Y/N Table Edit Default Value: N |
| 114 | INSTALLED_GP_CHE | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Switzerland
Y/N Table Edit Default Value: N |
| 115 | INSTALLED_GP_CHN | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll China
Y/N Table Edit Default Value: N |
| 116 | INSTALLED_GP_DEU | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Germany
Y/N Table Edit Default Value: N |
| 117 | INSTALLED_GP_ESP | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Spain
Y/N Table Edit Default Value: N |
| 118 | INSTALLED_GP_FRA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll France
Y/N Table Edit Default Value: N |
| 119 | INSTALLED_GP_HKG | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Hong Kong
Y/N Table Edit Default Value: N |
| 120 | INSTALLED_GP_IND | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll India
Y/N Table Edit Default Value: N |
| 121 | INSTALLED_GP_ITA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Italy
Y/N Table Edit Default Value: N |
| 122 | INSTALLED_GP_JPN | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Japan
Y/N Table Edit Default Value: N |
| 123 | INSTALLED_GP_MEX | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Mexico
Y/N Table Edit Default Value: N |
| 124 | INSTALLED_GP_MYS | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Malaysia
Y/N Table Edit Default Value: N |
| 125 | INSTALLED_GP_NLD | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Netherlands
Y/N Table Edit Default Value: N |
| 126 | INSTALLED_GP_NZL | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll New Zealand
Y/N Table Edit Default Value: N |
| 127 | INSTALLED_GP_SGP | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Singapore
Y/N Table Edit Default Value: N |
| 128 | INSTALLED_GP_THA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Thailand
Y/N Table Edit Default Value: N |
| 129 | INSTALLED_GP_UK | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll United Kingdom
Y/N Table Edit Default Value: N |
| 130 | INSTALLED_GP_USA | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll United States
Y/N Table Edit Default Value: N |
| 131 | PSECOMP_MGR | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft eCompensation Mgr
Y/N Table Edit Default Value: N |
| 132 | PSEPROFILE_MGR | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft eProfile Manager
Y/N Table Edit Default Value: N |
| 133 | PSERECRUIT_MGR | Character(1) | VARCHAR2(1) NOT NULL |
Talent Acquisition Mgmt
Y/N Table Edit Default Value: N |
| 134 | EPW | Character(1) | VARCHAR2(1) NOT NULL |
Installation Switch for the Employee Portal
Y/N Table Edit Default Value: N |
| 135 | FO_PBM | Character(1) | VARCHAR2(1) NOT NULL |
Used to identify whether the product Pay/Bill has been installed in the database.
Y/N Table Edit Default Value: N |
| 136 | AUTO_JOB_END | Character(1) | VARCHAR2(1) NOT NULL |
This is a flag on the Installation Table page which will indicate whether the system should or should not automatically end jobs on the Expected Job End Date.
Y/N Table Edit Default Value: N |
| 137 | AUTO_JOB_SUSPEND | Character(1) | VARCHAR2(1) NOT NULL |
This is a flag on the Installation Table page which will indicate whether the system should automatically suspend Substantive jobs when employees are assigned to Temporary Assignments.
Turning this flag on implies that Temporary Assignment is allowed.
Y/N Table Edit Default Value: N |
| 138 | TEMP_ASSGN_ID_LAST | Number(8,0) | INTEGER NOT NULL | This field holds the last Temporary Assignment number used. |
| 139 | EHC | Character(1) | VARCHAR2(1) NOT NULL |
HRMS Portal Pack
Y/N Table Edit Default Value: N |
| 140 | EPG | Character(1) | VARCHAR2(1) NOT NULL |
Government Portal
Y/N Table Edit Default Value: N |
| 141 | EPU | Character(1) | VARCHAR2(1) NOT NULL |
Campus Portal
Y/N Table Edit Default Value: N |
| 142 | APS_AUS | Character(1) | VARCHAR2(1) NOT NULL |
This unique ID is on the INSTALLATION table. When checked, it identifies the customer/industry as Australian Public Service.
Y/N Table Edit Default Value: N |
| 143 | DI | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the PeopleSoft Directory Interface Product
Y/N Table Edit Default Value: N |
| 144 | RP | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the PeopleSoft Resume Processing Product
Y/N Table Edit Default Value: N |
| 145 | INSTALLED_GP_ARG | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Argentina.
(Reserved field for possible future country extension development).
Y/N Table Edit Default Value: N |
| 146 | INSTALLED_GP_IRL | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Ireland
(Reserved field for possible future country extension development).
Y/N Table Edit Default Value: N |
| 147 | INSTALLED_GP_TWN | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Global Payroll Taiwan
(Reserved field for possible future country extension development).
Y/N Table Edit Default Value: N |
| 148 | TL_MOBILE | Character(1) | VARCHAR2(1) NOT NULL |
no longer used
Y/N Table Edit Default Value: N |
| 149 | PSEPERF_MANAGEMENT | Character(1) | VARCHAR2(1) NOT NULL |
PeopleSoft ePerformance
Y/N Table Edit Default Value: N |
| 150 | AA_ENABLED_JPN | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether the Japanese Additional Appointment functionality is being used in the system. A value of Y indicates that the functionality is being used. This field determines whether additional processing is performed on the Job component.
Y/N Table Edit Default Value: N |
| 151 | INSTALLED_PAY_PPS | Character(1) | VARCHAR2(1) NOT NULL |
Installation Flag for Payroll PIP - SAP
Y/N Table Edit Default Value: N |
| 152 | AV | Character(1) | VARCHAR2(1) NOT NULL |
Contributor Relations
Y/N Table Edit Default Value: N |
| 153 | SA | Character(1) | VARCHAR2(1) NOT NULL |
Student Administration
Y/N Table Edit Default Value: N |
| 154 | SG | Character(1) | VARCHAR2(1) NOT NULL |
Gradebook
Y/N Table Edit Default Value: N |
| 155 | HGA | Character(1) | VARCHAR2(1) NOT NULL |
Global Absence Flag
Y/N Table Edit |
| 156 | ELM | Character(1) | VARCHAR2(1) NOT NULL |
Enterprise Learning Management
Y/N Table Edit Default Value: N |
| 157 | PS_GL_VERSION | Character(10) | VARCHAR2(10) NOT NULL |
PeopleSoft General Ledger version.
Default Value: N/A |
| 158 | ADP | Character(1) | VARCHAR2(1) NOT NULL |
Field for the Installation Table to indicated whether the product Payroll Interface for ADP is installed.
Y/N Table Edit Default Value: N |
| 159 | RSRW | Character(1) | VARCHAR2(1) NOT NULL |
Project Identifier Flag for the Recruit Workforce product.
Y/N Table Edit Default Value: N |
| 160 | CSS | Character(1) | VARCHAR2(1) NOT NULL |
Product Identifier field for Campus Self Service
Y/N Table Edit |
| 161 | HMCF_VALID_CACHE | Character(1) | VARCHAR2(1) NOT NULL |
Cache Validations
N=No Y=Yes Default Value: N |
| 162 | HMCF_CACHE_RETAIN | Number(3,0) | SMALLINT NOT NULL |
Cache Retention Days
Default Value: 0 |
| 163 | HMCF_EIP_LIMIT | Number(4,0) | SMALLINT NOT NULL |
EIP Message Limit
Default Value: 1000 |
| 164 | LAST_OSHA_CASE_NBR | Number(5,0) | INTEGER NOT NULL | Last OSHA Case # Assigned: |
| 165 | GVT_NFC_INDICATOR | Character(1) | VARCHAR2(1) NOT NULL |
Federal NFC field
Y/N Table Edit Default Value: N |
| 166 | MILITARY | Character(1) | VARCHAR2(1) NOT NULL |
Military Installation
Y/N Table Edit Default Value: N |
| 167 | BEN_DED_CLS_ORDER | Character(1) | VARCHAR2(1) NOT NULL |
Benefits Deduction Class Order
1=EE After Tax Then PTax Benefit 2=PTax Benefit Then EE After Tax Default Value: 1 |
| 168 | TBH_SEQ_LAST | Number(12,0) | DECIMAL(12) NOT NULL | Template Sequence |
| 169 | ENC_TRIGGER | Character(1) | VARCHAR2(1) NOT NULL |
Encumbrance Trigger
Y/N Table Edit Default Value: Y |
| 170 | SAIP | Character(1) | VARCHAR2(1) NOT NULL |
SA Integration Pack
Y/N Table Edit Default Value: N |
| 171 | ARG | Character(1) | VARCHAR2(1) NOT NULL |
This field is used to identify the Argentine Functionality in HRMS
Y/N Table Edit Default Value: N |
| 172 | USA_TWO_QUESTION | Character(1) | VARCHAR2(1) NOT NULL | Two-Question Format(Ethnicity) |