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 returnedIf 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 |
| 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 |
