Understanding Alternate Character System Architecture
For certain names, addresses, and description fields in PeopleSoft HCM, there is a corresponding alternate character field that is part of the record. This architecture enables the users to enter the same proper nouns using two character sets.
Alternate Character Fields Associated with Global Pages
The following table lists the alternate character fields and the global pages with which they are associated in PeopleSoft HCM.
| Page | Auxiliary Page | Field | Comments |
|---|---|---|---|
|
BANK_BRANCH_EC |
BRANCH_NAME_AC |
||
|
BANK_EC |
BANK_NAME_AC |
||
|
COMPANY_TABLE1 |
COMPANY_ACDESCR_SEC |
DESCR_AC |
|
|
COMPANY_TABLE1 |
COMPANY_ACADDR_SEC |
COMPANY_ACADDR_SBP |
COMPANY_TBL.CITY_AC COMPANY_TBL.ADDRESS1_AC COMPANY_TBL.ADDRESS2_AC DERIVED_GBL.POSTAL_BTN ADDR_POS_JPN_SEC |
|
DEPEND_BENEF1 |
DEPENDBN_ACNAME_SEC |
NAME_AC |
|
|
ESTAB_TBL1_GBL |
ESTAB_ACDESCR_SEC |
DESCR_AC |
|
|
ESTAB_TBL1_GBL |
ESTAB_ACADDR_SEC |
ESTAB_ACADDR_SBP |
ESTAB_TBL.CITY_AC ESTAB_TBL.ADDRESS1_AC ESTAB_TBL.ADDRESS2_AC DERIVED_GBL.POSTAL_BTN |
|
HS_NON_EMPL1 |
HS_NE_ACNAME_SEC |
NAME_AC |
|
|
PERSONAL_DATA1 APP_PERSONAL_DATA1 |
PERSDTA_ACADDR_SEC |
PERSDTA_ACADDR_SBP |
PERS_DATA_EFFDT.CITY_AC PERS_DATA_EFFDT.ADDRESS1_AC PERS_DATA_EFFDT.ADDRESS2_AC DERIVED_GBL.POSTAL_BTN ADDR_POS_JPN_SEC |
|
PERSONAL_DATA1 APP_PERSONAL_DATA1 |
PERSDTA_ACNAME_SEC |
NAME_AC |
|
|
PYE_BANKACCT |
ACCOUNT_NAME_AC |
||
|
SRC_BANK |
ACCOUNT_NAME_AC |
||
|
STATE_NAMES_TBL |
STATE_ACDESCR_SEC |
DESCR_AC |
|
|
TRN_INSTRUCTR_TBL1 |
TRN_INS_ACNAME_SEC |
NAME_AC |
|
|
NAMES |
NAMES_ACPREFNM_SEC |
NAME_AC |
Search Records with Alternate Character Name Fields
The following PeopleSoft HCM search records that have NAME_AC (alternate character name) as an alternate search key or subrecords that are included in search records, enable for Japanese input and display:
-
NAMES
-
NAMES_SS_TMP
-
NE_INCIDNT_SRCH
-
NE_PERSONAL_DTA
-
OPR_ROWS_EE
-
OPR_ROWS_EE2
-
PERSON_NAME
-
PERS_SRCH_ALL
-
PHYSICIAN_SRCH
-
PHYSICIAN_SRCH2
-
SHS_EMPL_TAO
-
SHS_EXEMPT_TAO
-
SSF_PERSON_VW
-
SUCCESS_TR_SRCH
-
TRN_DMNDEE_SRCH
-
TRN_INSTR_SRCH
-
UPG_NAMES_TAO
-
WCS_NAME_SCH_VW
-
WF_PERSON_NAME
-
WORKER_PROMPT
Note:
This list includes only Human Resources system records.
PeopleSoft Human Resources Reports That Sort on Alternate Character Name
The following reports in PeopleSoft Human Resources sort on the Name field or on the Alternate Character Name field when the system base language and the report language are configured as shown:
| Base Language Set To | Report Language Set To | Report Sorted By |
|---|---|---|
|
English |
Japanese |
BASE.NAME_AC |
|
Japanese |
Japanese |
BASE.NAME_AC |
|
English |
English |
BASE.NAME |
|
Japanese |
English |
BASE.NAME |
SQR/BI Publisher Reports
These SQR/BI Publisher reports are sorted phonetically for Japanese, based on the report and the base language configuration:
| Report ID | Description |
|---|---|
|
PER001 |
Department Action Notices |
|
PER002 |
Employee Birthdays |
|
PER004 |
Emergency Contacts |
|
PER005 |
Employees on Leaves of Absence |
|
PER007 |
Temporary Employees |
|
PER009 |
Union Membership |
|
PER011 |
Company Skills Inventory |
|
PER012 |
Departmental Salaries |
|
PER013 |
Employee Compensation Changes |
|
PER020 |
Employee Home Address Listing |
|
PER023 |
Salary History |
|
CMP003 |
Compa-ratio Analysis by Grade and Job |
|
CMP004 |
Below-Minimum Analysis |
|
CMP005 |
Above-Maximum Analysis |
Note:
This list doesn't include country-specific regulatory reports that are sorted by Name.