!!!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 |
|DCC |
|DCN |
|DCO |
|DCR |
|DDP |
|DEN |
|DLN |
|DES |
|DFDF|
|DGC |
|DGF |
|DGR |
|DGS |
|DGVS|
|DGV |
|DHC |
|DPS |
|DIN |
|DJB |
|DLN |
|DSC |
|DSD |
|DSP |
|DTC |
|DTR |
|DTX |
|DUN |
|DWC |
|DWR |
|DCD |
|DCL |
|DIF |
|DOL |
|DFD |
|DOC |
|EAS_PERSON| returns [PERSON_CODE] for the employee whose record is being looked at
|EAS |
|ECT | 
|EID |
|EPL |
|EEM | returns [PERSON_CODE] for the employee whose record is being looked at
|FBP |
|FBU |
|FAS |
|FBSD| returns the [BUDGET_SEAT_CODE] concatenated with the Julian date of the effective date
|FBS |
|FBR |
|FCA |
|FSN |
|FVP |
|HIN |
|HHI |
|LDT |
|LDI |
|LGR |
|LGV |
|LIT |
|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]
|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] concatenated with the [TAX_CLAIM_CODE] (hyphen separated)
|PCRD|
|PLPL|
|PJE |
|PWC |
|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]