INSTALLATION_PY(SQL Table) |
Index Back |
|---|---|
PNA Installation tablePayroll for North America Installation table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACCT_CD_LAST | Number(18,0) | DECIMAL(18) NOT NULL | Last Account Cd Assigned |
| 2 | AP_INVNO_PREFIX | Character(1) | VARCHAR2(1) NOT NULL |
AP Invoice Number Prefix
Default Value: P |
| 3 | AP_INVNO_LAST | Number(7,0) | INTEGER NOT NULL | Last AP Invoice Number |
| 4 | CPS_TRANS_ID_LAST | Number(8,0) | INTEGER NOT NULL | Last CPS Transmission ID Nbr |
| 5 | FILE_CREATE_LAST | Number(4,0) | SMALLINT NOT NULL | Last Dir Dep File Creation Nbr |
| 6 | ROE_NBR_LAST | Number(8,0) | INTEGER NOT NULL | Last ROE # Used (Canadian) |
| 7 | RETROPAY_SEQ_LAST | Number(15,0) | DECIMAL(15) NOT NULL | Last Retropay Request # |
| 8 | WC_AUDIT_EXCEPTION | Character(1) | VARCHAR2(1) NOT NULL |
This indicates if batch process will generate audit exceptions data for WorkCenter.
Y/N Table Edit Default Value: N |
| 9 | DIRDEP_MASK_EE | Character(1) | VARCHAR2(1) NOT NULL |
Label for masking option on PY installation page.
Y/N Table Edit Default Value: N |
| 10 | DIRDEP_MASK_ADMIN | Character(1) | VARCHAR2(1) NOT NULL |
Label for masking option on PY installation page.
Y/N Table Edit Default Value: N |
| 11 | DIRDEP_MASK_WAGE | Character(1) | VARCHAR2(1) NOT NULL |
Label for masking option on PY installation page.
Y/N Table Edit Default Value: N |
| 12 | PSHUP_INACT_EMP | Character(1) | VARCHAR2(1) NOT NULL |
This indicates if PSHUP Inactive Employees feature will be used by the customer
Y/N Table Edit Default Value: N |
| 13 | PY_OFF_CYCLE_DD | Character(1) | VARCHAR2(1) NOT NULL |
Process off-cycle direct deposit indicator.
Y/N Table Edit Default Value: N |
| 14 | PY_EE_PAYCHECK_DT | Character(1) | VARCHAR2(1) NOT NULL |
Use Pay Check Date on Employee's pay check
Y/N Table Edit Default Value: N |
| 15 | MIN_WAGE_JUR | Character(1) | VARCHAR2(1) NOT NULL |
Field used for enabling Minimum Wage Jurisdiction feature
N=No Y=Yes Default Value: N |
| 16 | PY_QUICK_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Enable Quick Calculation
Y/N Table Edit Default Value: N |
| 17 | PY_DISABLE_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Disable Calculate after FC
Y/N Table Edit Default Value: N |
| 18 | PY_DISP_ALT_VW_CAN | Character(1) | VARCHAR2(1) NOT NULL |
Display Alteranative View Canada
Y/N Table Edit |
| 19 | PY_DISP_ALT_VW_US | Character(1) | VARCHAR2(1) NOT NULL |
Form W-2/W-2c
Y/N Table Edit |
| 20 | PY_DISP_ALT_VW_NRA | Character(1) | VARCHAR2(1) NOT NULL |
Alternate View For Non Resident Alien
Y/N Table Edit Default Value: N |
| 21 | PY_DISP_ALT_VW_RET | Character(1) | VARCHAR2(1) NOT NULL |
Alternet Vew for Retirees
Y/N Table Edit Default Value: N |
| 22 | PY_VW_W2_PDF_STD | Character(1) | VARCHAR2(1) NOT NULL |
View W2 Consolidated PDF in Standard Mode
Y/N Table Edit Default Value: N |
| 23 | PY_VW_W2_PDF_SREAD | Character(1) | VARCHAR2(1) NOT NULL |
View W2 Consolidated PDF in Screen Reader Mode
Y/N Table Edit Default Value: N |
| 24 | PY_TAX_PREP_SS | Character(1) | VARCHAR2(1) NOT NULL |
Display W-2 Export Consent
Y/N Table Edit Default Value: N |
| 25 | HP_CC_ACTDIST | Character(1) | VARCHAR2(1) NOT NULL |
Actuals Distribution Concurrent Process
Y/N Table Edit Default Value: N |
| 26 | PY_TAX_PREP_DFLT | Character(1) | VARCHAR2(1) NOT NULL |
W-2 Export Default Status
Y/N Table Edit Default Value: N |
| 27 | PY_PREB_DIRDEP_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable Direct Deposit in ESS for pre boarding employees
Y/N Table Edit Default Value: N |
| 28 | PY_PREB_VD_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable Voluntary Deductions in employee self service for preboarding
Y/N Table Edit Default Value: N |
| 29 | PY_PREB_TD1_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable TD1 in employee self service for preboarding
Y/N Table Edit Default Value: N |
| 30 | PY_PREB_W4_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable W4 for employee self service for preboarding
Y/N Table Edit Default Value: N |
| 31 | PY_PREB_W2_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable W-2/W-2c Consent in employee self service for preboarding
Y/N Table Edit Default Value: N |
| 32 | PY_PREB_1042S_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable 1042-S Consent in employee self service for preboarding
Y/N Table Edit Default Value: N |
| 33 | PY_PREB_1099R_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable 1099-R Consent in employee self service for preboarding
Y/N Table Edit Default Value: N |
| 34 | PY_PREB_RL_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable RL-1/RL-2 Consent for employee self service for preboarding
Y/N Table Edit Default Value: N |
| 35 | PY_PREB_T4_SS | Character(1) | VARCHAR2(1) NOT NULL |
Enable T4/T4A Consent for employee self service for preboarding
Y/N Table Edit Default Value: N |
| 36 | PY_OK_TO_PAY_ALL | Character(1) | VARCHAR2(1) NOT NULL |
OK to Pay All
Y/N Table Edit Default Value: N |
| 37 | PY_EXP_BY_DEF | Character(1) | VARCHAR2(1) NOT NULL |
Expanded By Default
Y/N Table Edit Default Value: N |
| 38 | PY_DISP_VIEW_SUMM | Character(1) | VARCHAR2(1) NOT NULL |
Enable OK to Pay Summary
Y/N Table Edit Default Value: N |
| 39 | PY_INCL_RETRO_ERN | Character(1) | VARCHAR2(1) NOT NULL |
Include Retro Earnings
Y/N Table Edit Default Value: N |
| 40 | SELECT_ALL | Character(1) | VARCHAR2(1) NOT NULL |
Select All
Y/N Table Edit Default Value: N |