P2K_SMGCD#

Functionality:#

This database function will return the actual code value for a specific ID, upon identifying the source table.

Parameters:#

CODE_ID The actual ID field within the database
TABLE_ALIAS This is the abbreviation for the table (you can see this in IMTD) for the corresponding code

Returns: #

Varchar2(30)

Errors: #

If an invalid parameter is passed, then NULL is returned

If there is no value or record for that ID and alias pair, then NULL is returned

Example: #

P2K_SMGCD(DPS_ID,'DPS')

Table Aliases Supported #

(as at Jun 1, 2008 – more may be added with each release) CLEANUP
ALPC
ALPT
ALP
AAC
AAR
MCD
MUC
MUS
MNT
MEX
MFG
MPD
MTD
MLN
MLQ
MFN
MMI
MMS
MMU
MRO
MCT
MUF
MVD
MWA
MDAO
MWC
BBCR
BBC
BPN
BCGC
BCG
BRM
BPT
BBR
CCCU
CCC
CCG
CDA
CDP
CRSC
CRS
CTS
DAA AUTHORIZATION_CODE
DCC COST_CENTER_CODE
DCN COUNTY_NAME, STATE_PROVINCE_CODE, COUNTRY_CODE
DCO COUNTRY_CODE
DCR CHANGE_CODE
DDP DEPARTMENT_CODE
DEN ENTITY_CODE
DES STATUS_CODE
DFDF FIELD_SEQUENCE
DGC GL_COMPANY_CODE
DGF GL_FUNC_CODE
DGR GROUP_CODE
DGS GL_SEGMENT_NUMBER
DGVS GOVT_REGIST_SET_CODE
DGV GOVT_REGIST_NUMBER
DHC HOLIDAY_CALENDAR_CODE
DPS POSITION_CODE
DIN INDUSTRY_CODE
DJB JOB_CODE
DLN LOCATION_CODE
DSC STAT_CODE
DSD SCHOOL_DISTRICT_NAME, STATE_PROVINCE_CODE, COUNTRY_CODE
DSP STATE_PROVINCE_NAME, COUNTRY_CODE
DTC TIME_CODE
DTR TERMINATION_CODE
DTX JURISDICTION_NAME, STATE_PROVINCE_CODE, COUNTRY_CODE (GEO_TYPE)
DUN UNIT_CODE
DWC WORK_CALENDAR_CODE
DWR WORK_RULE_CODE
DCD CALENDAR_PERIOD
DCL CALENDAR_CODE
DIF INTERFACE_CODE
DOL ORG_LEVEL_CODE
DFD FORM_CODE
DOC OCCUPATION_CODE
EAS_PERSON PERSON_CODE for the employee whose P2K_HR_ASSIGNMENTS record is being looked at
EAS ASSIGNMENT_TYPE-ASSIGNMENT_CODE
ECT EMPLOYER-LAST_NAME,FIRST_NAMEemployer is truncated at 10 characters
EID PERSON_CODE
EPL PEOPLE_LIST_CODE
EEM PERSON_CODE for the employee being looked at
FBP BUDGET_PLAN_CODE
FBU BUDGET_CODE
FAS ASSUMPTION_SEQUENCE
FBSD BUDGET_SEAT_CODEddd where ddd is the Julian date of the effective date
FBS BUDGET_SEAT_CODE
FBR BUDGET_AREA_CODE
FCA COST_ACCOUNT_CODE
FSN SCENARIO_CODE
FVP VIEWPOINT_CODE
HIN INCIDENT_CODE
HHI CASE_NUMBER
LDT DISPUTE_TYPE_CODE
LDI DISCIPLINARY_CODE
LGR GRIEVANCE_RULE_CODE
LGV GRIEVANCE_CODE
LIT ISSUE_TYPE_CODE
PFQ FREQUENCY_CODE
PEL ELEMENT_CODE
PPC PC_CODE
PPCD PC_DETAIL_TYPE
PPA PAYROLL_CODE
PPP PAY_PERIOD
PCT PAY_CATEGORY_CODE
PRN PAY_RUN_NUMBER
PGR IDthe ID of the P2K_PR_GVT_RUNS record
PBT BATCH_NUMBER
PPTS PAY_POINT_SET_CODE
PBL BANK_TRANSIT_CODE
PBA BANK_ACCOUNT
PCL PAY_CALENDAR_CODE
PCU PC_USAGE_CODE
PPH PAY_NUMBER
PCC TAX_CLAIM_TYPE-TAX_CLAIM_CODE
PCRD TAX_RATE_CODE
PLPL BATCH_CODE
PJE DISTRIBUTION_CODE
PWC WC_REGISTRATION_NUMBER
RAP APPLICATION_CODE
RAS ASSESSMENT_CODE
RCA CANDIDATE_CODE
RRE RECRUITER_CODE
RJP JOB_PROFILE_CODE
RPO POSTING_CODE
RQS SUBTYPE_CODE
RQU QUESTION_CODE
RSTP STEP_SEQUENCE
RST STAGE_SEQUENCE
SRT REVIEW_TYPE_CODE
SRV REVIEW_NUMBER
SSR RANGE_CODE
SPA PA_NUMBER
SPM PREMIUM_CODE
SPT PREMIUM_TYPE_CODE
SPYC COLUMN_SEQUENCE
SPY PA_TYPE_CODE
SWSS SCALE_STEP
SWSR WAGE_STEP_RULE_CODE
SWS SCALE_CODE
TCD CLOCK_DEVICE_CODE
TBT TIME_BATCH_CODE/TIME_BATCH_NUMBER
TES EVENT_SITE_CODE
TRT TIME_RULE_TYPE_CODE
TSS SHIFT_CODE
TTE TIME_ENTRY_STATUS
TTP WORK_TEAM_CODE with ranking STATION_POST_RANK
TTX TIME_EXCEPTION_STATUS
TWA WORK_AREA_CODE
TWD WORK_DIVISION_CODE
TWSP STATION_POST_RANK
TWS WORK_STATION_CODE
TWT WORK_TEAM_CODE
XPN PENSION_PLAN_CODE
XPO PENSION_OPTION_CODE
XPC PN_CODE
XPCR PN_RULE_CODE
XPCT PAYMENT_CATEGORY_CODE
XPT PENSION_TABLE_CODE
XST PENSION_STATUS_CODE
XPA PENSION_ACCOUNT_CODE