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	COMPONENT_SEQUENCE
ALPT	LEAVE_TYPE_CODE
ALP	LEAVE_POLICY_CODE
AAC	AC_CODE
AAR	AC_RULE_CODE
MCD	COLUMN_NAME
MEX	MEDIA_CODE/TABLE_NAME
MUC	USER_CALC_CODE
MUS	USER_NAME
MNT	NOTE_TYPE_CODE
MEX	ID-FUNCTION_NAME
MFG	FG_CODE
MOB	OBJECT_CODE - ATTRIBUTE_CODE
MPD	PRODUCT_CODE
MPF	PREFERENCE_CODE
MTD	TABLE_NAME
MLN	LEXICON_NAME
MLQ	LOV_CODE
MFN	FUNCTION_NAME
MMI	MENU_ITEM_CODE
MMS	MESSAGE_CODE
MMU	MENU_CODE
MRO	ROLE_NAME
MLA	COUNTRY_CODE - ROLE_NAME - LANGUAGE_CODE
MRT	REQUEST_TYPE_CODE
MCT	CUSTOM_TABLE_CODE
MUF	FIELD_SEQUENCE
MVD	VIEW_NAME
MWA	EVENT_CODE
MDAO	DATA_SOURCE_NAME
MWC	WHERE_CLAUSE_CODE
BBCR	BC_RULE_CODE
BBC	BC_CODE
BPN	PLAN_CODE
BCGC	BC_CODE BC_RULE_CODE	BC_CODE is made 5 characters long
BCG	COVERAGE_CODE
BRM	REMIT_REPORT_CODE
BPT	PLAN_TYPE_CODE
BBR	BC_RULE_CODE
CCCU	LEVEL_CODE
CCC	COMPETENCE_CODE
CCG	CATEGORY_CODE
CDA	ACTIVITY_SEQUENCE
CDP	PROGRAM_CODE
CRSC	CLASS_CODE
CRS	COURSE_CODE
CTS	SUPPLIER_CODE
DAA	AUTHORIZATION_CODE
DCC	COST_CENTER_CODE
DCN	COUNTY_NAME, STATE_PROVINCE_CODE, COUNTRY_CODE
DCO	COUNTRY_CODE
DCR	CHANGE_CODE
DDP	DEPARTMENT_CODE
DEN	ENTITY_CODE
DES	STATUS_CODE
DFDF	FIELD_SEQUENCE
DGC	GL_COMPANY_CODE
DGF	GL_FUND_CODE
DGR	GROUP_CODE
DGS	GL_SEGMENT_NUMBER
DGVS	GOVT_REGIST_SET_CODE
DGV	GOVT_REGIST_NUMBER
DHC	HOLIDAY_CALENDAR_CODE
DPS	POSITION_CODE
DIN	INDUSTRY_CODE
DJB	JOB_CODE
DLN	LOCATION_CODE
DSC	STAT_CODE
DSD	SCHOOL_DISTRICT_NAME, STATE_PROVINCE_CODE, COUNTRY_CODE
DSP	STATE_PROVINCE_NAME, COUNTRY_CODE
DTC	TIME_CODE
DTR	TERMINATION_CODE
DTX	JURISDICTION_NAME, STATE_PROVINCE_CODE, COUNTRY_CODE (GEO_TYPE)
DUN	UNIT_CODE
DWC	WORK_CALENDAR_CODE
DWR	WORK_RULE_CODE
DCD	CALENDAR_PERIOD
DCL	CALENDAR_CODE
DIF	INTERFACE_CODE
DOL	ORG_LEVEL_CODE
DFD	FORM_CODE
DOC	OCCUPATION_CODE
EAS_PERSON	PERSON_CODE	for the employee whose P2K_HR_ASSIGNMENTS record is being looked at
EAS	ASSIGNMENT_TYPE-ASSIGNMENT_CODE
ECT	EMPLOYER-LAST_NAME,FIRST_NAME	employer is truncated at 10 characters
EID	PERSON_CODE
EPL	PEOPLE_LIST_CODE
EEM	PERSON_CODE	for the employee 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	the ID of the P2K_PR_GVT_RUNS record
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