!!!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| [COMPONENT_SEQUENCE]|
|ALPT| [LEAVE_TYPE_CODE]|
|ALP | [LEAVE_POLICY_CODE]|
|AAC | [AC_CODE]|
|AAR | [AC_RULE_CODE]|
|MCD | [COLUMN_NAME]|
|MEX | [MEDIA_CODE]/[TABLE_NAME]|
|MUC | [USER_CALC_CODE]|
|MUS | [USER_NAME]|
|MNT | [NOTE_TYPE_CODE]|
|MEX | [ID|MEX_ID]-[FUNCTION_NAME]|
|MFG | [FG_CODE]|
|MOB | [OBJECT_CODE] - [ATTRIBUTE_CODE]|
|MPD | [PRODUCT_CODE]|
|MPF | [PREFERENCE_CODE]|
|MTD | [TABLE_NAME]|
|MLN | [LEXICON_NAME]|
|MLQ | [LOV_CODE]|
|MFN | [FUNCTION_NAME]|
|MMI | [MENU_ITEM_CODE]|
|MMS | [MESSAGE_CODE]|
|MMU | [MENU_CODE]|
|MRO | [ROLE_NAME]|
|MLA | [COUNTRY_CODE] - [ROLE_NAME] - [LANGUAGE_CODE]|
|MRT | [REQUEST_TYPE_CODE]|
|MCT | [CUSTOM_TABLE_CODE]|
|MUF | [FIELD_SEQUENCE]|
|MVD | [VIEW_NAME]|
|MWA | [EVENT_CODE]|
|MDAO| [DATA_SOURCE_NAME]|
|MWC | [WHERE_CLAUSE_CODE]|
|BBCR| [BC_RULE_CODE]|
|BBC | [BC_CODE]|
|BPN | [PLAN_CODE]|
|BCGC| [BC_CODE]/[BC_RULE_CODE]|''BC_CODE is made 5 characters long''
|BCG | [COVERAGE_CODE]|
|BRM | [REMIT_REPORT_CODE]|
|BPT | [PLAN_TYPE_CODE]|
|BBR | [BC_RULE_CODE]|
|CCCU| [LEVEL_CODE]|
|CCC | [COMPETENCE_CODE]|
|CCG | [CATEGORY_CODE]|
|CDA | [ACTIVITY_SEQUENCE]|
|CDP | [PROGRAM_CODE]|
|CRSC| [CLASS_CODE]|
|CRS | [COURSE_CODE]|
|CTS | [SUPPLIER_CODE]|
|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_FUND_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_NAME]|''employer 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_CODE]__ddd__|  ''where __ddd__ is the [Julian date|JULIAN DATE] of the [effective|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 | [ID|PGR_ID]|''the 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_CODE]/[STEP_CODE]|
|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]|