TABLES-CM
Table NameAliasDescription
P2K_CM_ALLOCATIONSDALAllocations
P2K_CM_APPROVAL_LEVELSDAPLApproval Levels
P2K_CM_APPROVAL_LOGSDAPApproval Logs
P2K_CM_APPROVAL_PROCESSESDAPP
P2K_CM_APPROVAL_RECORDSDAPR
P2K_CM_APPROVAL_RIGHTSDARApproval Rights
P2K_CM_APPROVAL_STEPSDAPS
P2K_CM_APPROVERSDAPA
P2K_CM_AUTHORIZATION_AREASDAASecurity access used for refining people lists.
P2K_CM_CALENDARSDCLHeader for calendar details.
P2K_CM_CALENDAR_DETAILSDCDHolds a row per period of time.
P2K_CM_CHANGE_REASONSDCRChange Reasons
P2K_CM_CHANGE_REASON_USAGESDCRU
P2K_CM_CITIESDCICities (for taxation)
P2K_CM_COORDINATORSDCORDepartment Coordinators
P2K_CM_COST_CENTERSDCCCost Centers
P2K_CM_COST_CENTER_SECURITIESDCCS
P2K_CM_COUNTIESDCNCounties
P2K_CM_COUNTRIESDCOCountries around the world
P2K_CM_DEPARTMENTSDDPDepartment code and standing.
P2K_CM_DEPARTMENT_DETAILSDDDDate sensitive department information.
P2K_CM_DISTRIBUTIONSDDSRules for splitting dollars to different distr cod
P2K_CM_EMPLOYMENT_STATUSESDESDefines Work Status Codes.
P2K_CM_ENTITIESDENA legal entity registered with the government.
P2K_CM_ENTITY_DETAILSDEDDate sensitive details about an entity.
P2K_CM_FORM_DEFINITIONSDFDForm Definitions
P2K_CM_FORM_FIELDSDFDFForm Fields
P2K_CM_FORM_VARIABLESDFDVForm Variables
P2K_CM_GL_ACCOUNTSDGAInformation about all the GL Accounts.
P2K_CM_GL_COMPANIESDGCUsed to roll GL entries to.
P2K_CM_GL_FUNDSDGF
P2K_CM_GL_FUND_DETAILSDGFD
P2K_CM_GL_FUND_ELEMENTSDGFE
P2K_CM_GL_SEGMENTSDGSBreakdown of GL Distribution code
P2K_CM_GL_SEGMENT_VALUESDGSVGl Segment Values
P2K_CM_GOVT_RATESDGTGovt Rates
P2K_CM_GOVT_RATE_DETAILSDGTDDate sensistive registration details.
P2K_CM_GOVT_REGISTRATIONSDGVGovernment Registration Number and Type.
P2K_CM_GOVT_REGIST_SETSDGVSGovt Regist Sets
P2K_CM_GROUPSDGRHeader for Group Details
P2K_CM_GROUP_DETAILSDGDDate Sensitive Group information.
P2K_CM_GROUP_ELEMENTSDGREGroup Elements
P2K_CM_HOLIDAY_CALENDARSDHCHeader for Holiday Calendar Details.
P2K_CM_HOLIDAY_DETAILSDHDHolidays Information
P2K_CM_INDUSTRIESDINIndustries
P2K_CM_INTERFACE_FIELDSDIFDInterface Fields
P2K_CM_INTERFACE_FORMATSDIFInterface Formats
P2K_CM_JOBSDJBHeader for Job Details
P2K_CM_JOB_DETAILSDJDDate Sensitive information for a job.
P2K_CM_JOB_SKILLSDJS
P2K_CM_LOADED_GEOCODESDLGLoaded Geocodes
P2K_CM_LOCATIONSDLNLocation information
P2K_CM_MUNICIPALITIESDMNMunicipalities (for taxation)
P2K_CM_OCCUPATIONSDOCOccupations
P2K_CM_ORG_LEVELSDOLThe various organization levels.
P2K_CM_ORG_LEVEL_DETAILSDOLDWhich departments apply to which organization leve
P2K_CM_POSITIONSDPSStores the position info that does not change over
P2K_CM_POSITION_DETAILSDPDHolds Date Effective information about a position.
P2K_CM_SCHOOL_DISTRICTSDSDAll school district names and codes.
P2K_CM_STATE_PROVINCESDSPStates and provinces around the world
P2K_CM_STATISTIC_COMPONENTSDSCStatistic Components
P2K_CM_TAX_JURISDICTIONSDTXGeographical areas
P2K_CM_TERMINATION_REASONSDTRTermination Reasons
P2K_CM_TIME_CODESDTCTime Codes
P2K_CM_TIME_CODE_SETSDTCSA component of a product - can be screens, report
P2K_CM_TIME_CODE_SET_DETAILSDTCDA component of a product - can be screens, report
P2K_CM_UNITSDUNHeader for Unit Details.
P2K_CM_UNIT_DETAILSDUDContract specific information.
P2K_CM_WORK_CALENDARSDWCWork Calendars
P2K_CM_WORK_CALENDAR_DETAILSDWCDWork Calendar Details
P2K_CM_WORK_RULESDWRAdditional rules tied to group.
P2K_CM_WORK_RULE_DETAILSDWRDHours per specific day of a period
P2K_CM_WORK_RULE_TIME_CODESDWRCWork Rule Time Codes
P2K_CM_WORK_TIME_RULESDWTWork Time Rules
P2K_CM_ZIP_RANGESDZRZip Ranges


Notes #

Click to create a new notes page