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