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 |
Screen captures are meant to be indicative of the concept being presented and may not reflect the current screen design.
If you have any comments or questions please email the Wiki Editor
All content © High Line Corporation