Wiki: P 2 K

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	BUDGET_PLAN_CODE
FBU	BUDGET_CODE
FAS	ASSUMPTION_SEQUENCE
FBSD	BUDGET_SEAT_CODEddd where ddd is the Julian date of the effective date
FBS	BUDGET_SEAT_CODE
FBR	BUDGET_AREA_CODE
FCA	COST_ACCOUNT_CODE
FSN	SCENARIO_CODE
FVP	VIEWPOINT_CODE
HIN	INCIDENT_CODE
HHI	CASE_NUMBER
LDT	DISPUTE_TYPE_CODE
LDI	DISCIPLINARY_CODE
LGR	GRIEVANCE_RULE_CODE
LGV	GRIEVANCE_CODE
LIT	ISSUE_TYPE_CODE
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-TAX_CLAIM_CODE
PCRD	TAX_RATE_CODE
PLPL	BATCH_CODE
PJE	DISTRIBUTION_CODE
PWC	WC_REGISTRATION_NUMBER
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