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
PEL
PPC
PPCD
PPA
PPP
PCT
PRN
PBT
PPTS
PBL
PBA
PCL
PCU
PPH
PCC returns the TAX_CLAIM_TYPE concatenated with the TAX_CLAIM_CODE (hyphen separated)
PCRD
PLPL
PJE
PWC
RAP
RAS
RCA
RRE
RJP
RPO
RQS
RQU
RSTP
RST
SRT
SRV
SSR
SPA
SPM
SPT
SPYC
SPY
SWSS
SWSR
SWS
TBT
TES
TRT
TSS
TTE
TTP returns WORK_TEAM_CODE ‘ with ranking ‘ STATION_POST_RANK
TTX
TWA
TWD
TWSP
TWS
TWT
XPN
XPO
XPC
XPCR
XPCT
XPT
XST
XPA