!!!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_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_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]|