Alias: MRT#

(P2K_AM_REQUEST_TYPES)

Unique Keys: REQUEST_TYPE_CODE

ERD: ERD-AM80

description

Table Columns#

Column nameData Type / SizeDomainMand.Notes
IDNumber(10)IDY
REQUEST_TYPE_CODEVarchar2(16)CODEY
REQUEST_PURPOSEVarchar2(2)X_REQUEST_PURPOSE
REQUIRES_ACTIONVarchar2(1)TOGGLE
CREATE_DATEDate()DATEY
CREATE_USERVarchar2(30)VARCHAR30Y
CHANGE_DATEDate()DATEY
CHANGE_USERVarchar2(30)VARCHAR30Y
MTD_IDNumber(10)ID link to P2K_AM_TABLE_DETAILS
MWC_IDNumber(10)ID link to P2K_AM_WHERE_CLAUSES
REQUEST_TYPE_USAGEVarchar2(2)X_LEXICON_USAGE
DESCRIPTIONVarchar2(50)DESCRIPTION
MFN_IDNumber(10)ID link to P2K_AM_FUNCTIONS
EPL_IDNumber(10)ID link to P2K_HR_PEOPLE_LISTS
RECIPIENT_TYPEVarchar2(2)X_RECIPIENT_TYPE
RESTRICT_TO_FUNCTIONSVarchar2(4000)VARCHAR4000

Derived Fields#

Column Name
DRV_RESTRICT_TO_FUNCTIONS

User Fields: Not Allowed
Audit Logging: Not Allowed


Notes #

Click to create a new notes page