Thursday, 8 October 2020

Earnings Program Table

Set Up HCM > Product Related > Payroll for North America > Compensation and Earnings > Earnings Program Table

select ERN_PROGRAM, EFFDT, EFF_STATUS, DESCR, DESCRSHORT

from ps_ERN_PROGRAM_TBL;

select ERN_PROGRAM, EFFDT, ERNCD

from ps_ERN_PROGRAM_DEF;

Earnings Table

Set Up HCM > Product Related >Payroll for North America > Compensation and Earnings > Earnings Table

select ERNCD, to_char(effdt,'yyyy-mm-dd') as effdt, EFF_STATUS, DESCR, DESCRSHORT, ERN_SEQUENCE, MAINTAIN_BALANCES, BUDGET_EFFECT, ALLOW_EMPLTYPE, PAYMENT_TYPE, HRLY_RT_MAXIMUM, PERUNIT_OVR_RT, EARN_FLAT_AMT, ADD_GROSS, SUBJECT_FWT, SUBJECT_FICA, SUBJECT_FUT, SUBJECT_CIT, SUBJECT_CUI, SUBJECT_CUI_HOURS, SUBJECT_CPP, SUBJECT_QIT, SUBJECT_QPP, SUBJECT_TRUE_T4GRS, SUBJECT_TRUE_RVGRS, SUBJECT_PAY_TAX, SUBJECT_REG, WITHHOLD_FWT, HRS_ONLY, SHIFT_DIFF_ELIG, TAX_GRS_COMPNT, SPEC_CALC_RTN, FACTOR_MULT, FACTOR_RATE_ADJ, FACTOR_HRS_ADJ, FACTOR_ERN_ADJ, GL_EXPENSE, SUBTRACT_EARNS, DEDCD_PAYBACK, TAX_METHOD, EARN_YTD_MAX, BASED_ON_TYPE, BASED_ON_ERNCD, BASED_ON_ACC_ERNCD, AMT_OR_HOURS, PNA_USE_SGL_EMPL, ELIG_FOR_RETROPAY, USED_TO_PAY_RETRO, EFFECT_ON_FLSA, FLSA_CATEGORY, REG_PAY_INCLUDED, TIPS_CATEGORY, ADD_DE, SUBJECT_T4A, SUBJECT_RV2, GVT_BENEFITS_RATE, GVT_CPDF_ERNCD, GVT_OTH_PAY, GVT_PAY_CAP, GVT_PREM_PAY, GVT_OT_PAY_IND, GVT_ADD_TO_SF50_52, GVT_INCLUDE_LOC, GVT_IRR_REPORTABLE, GVT_IRR_LWOP, GVT_SF113A_LUMPSUM, GVT_SF113A_WAGES, GVT_FEFFLA, GVT_FMLA, GVT_LV_EARN_TYPE, INCOME_CD_1042, PERMANENCY_NLD, TAX_CLASS_NLD, HRS_DIST_SW, HP_ADMINSTIP_FLAG, SUBJECT_QPIP

from ps_EARNINGS_TBL

where erncd like 'MP%';

Create Additional Pay

/c/MAINTAIN_PAYROLL_DATA_US.ADDITIONAL_PAY.USA

Payroll for North America > Employee Pay Data USA > Create Additional Pay

Level 0

select EMPLID, EMPL_RCD, ERNCD, RECORD_SOURCE

from ps_ADDL_PAY_ERNCD

where erncd like 'M%';

Level 1

select EMPLID, EMPL_RCD, ERNCD, to_char(effdt,'yyyy-mm-dd') as effdt, RECORD_SOURCE

from ps_ADDL_PAY_EFFDT

where erncd like 'M%';

Level 2

select EMPLID, EMPL_RCD, ERNCD, to_char(effdt,'yyyy-mm-dd') as effdt, ADDL_SEQ, DEPTID, JOBCODE, POSITION_NBR, ACCT_CD, GL_PAY_TYPE, ADDL_PAY_SHIFT, OTH_HRS, HOURLY_RT, OTH_PAY, ADDLPAY_REASON, SEPCHK, EARNINGS_END_DT, GOAL_AMT, GOAL_BAL, OK_TO_PAY, DISABLE_DIR_DEP, PRORATE_ADDL_PAY, PRORATE_CUI_WEEKS, PAY_PERIOD1, PAY_PERIOD2, PAY_PERIOD3, PAY_PERIOD4, PAY_PERIOD5, STATE, LOCALITY, TAX_PERIODS, TAX_METHOD, ADDL_PAY_FREQUENCY, DED_TAKEN, DED_SUBSET_ID, DED_TAKEN_GENL, DED_SUBSET_GENL, PLAN_TYPE, BUSINESS_UNIT, COMP_RATECD, RECORD_SOURCE

from PS_ADDL_PAY_DATA

where erncd like 'M%';

Wednesday, 7 October 2020

Handling File Attachment Size Dynamically

Handling File Attachment Size Dynamically:

We can easily hardcode the File Size limit by setting a value to the &size variable in below code.

But if we want to use it dynamically, then we can get the value and use Int to convert the value to an integer and use it. Since Value(&size) returns a decimal value, it is not accepted.

&size = Int(&fsize);

&RETCODE = AddAttachment(URL.AF_MOBILE_USER_SS_FILE, &UniqueSysFilename, "", &ATTACHUSERFILE, &size * 1024);

The dynamic value can be stored in any setup or in a message catalog and pulled using below code, where 678 id default value in case message catalog 123,45 doesnt have this value.

&fsize = MsgGetText(123, 45, "678");

File Extension List

Setting up and Migrating File Extension List

select * from ps_PTFX_EXTLSTDEFN;

select * from PS_PTFX_EXTLST where PTFX_EXTLST_NAME = 'GSS_EXTENSION_LIST';

For more configuration details check the below:

https://docs.oracle.com/cd/F13639_01/psft/pdf/pt857tsvt-b122018.pdf

Chapter 9

Using PeopleTools Utilities

For Migration suggestions check the below:

https://docs.oracle.com/cd/E40124_01/psft/acrobat/PeopleSoft-Portal-Solutions-9.0-to-9.1-Revision-2-Upgrade_032013.pdf

Applying Application Changes

Chapter 5

Task 5-13-21: Exporting File Extension Lists This script exports the definition and contents of every file extension list defined for attachments in the new release. The script name for your upgrade path is: PTFX_EXTLSTS_EXP.DMS

Task 5-13-22: Importing File Extension Lists This script imports the definition and contents of every file extension list delivered in the new release. Note that for any duplicates, this script will overwrite any customizations that were made. The script name for your upgrade path is: PTFX_EXTLSTS_IMP.DMS