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