Wiki: TABLES-CM

Table Name	Alias	Description
P2K_CM_ALLOCATIONS	DAL	Allocations
P2K_CM_APPROVAL_LEVELS	DAPL	Approval Levels
P2K_CM_APPROVAL_LOGS	DAP	Approval Logs
P2K_CM_APPROVAL_PROCESSES	DAPP
P2K_CM_APPROVAL_RECORDS	DAPR
P2K_CM_APPROVAL_RIGHTS	DAR	Approval Rights
P2K_CM_APPROVAL_STEPS	DAPS
P2K_CM_APPROVERS	DAPA
P2K_CM_AUTHORIZATION_AREAS	DAA	Security access used for refining people lists.
P2K_CM_CALENDARS	DCL	Header for calendar details.
P2K_CM_CALENDAR_DETAILS	DCD	Holds a row per period of time.
P2K_CM_CHANGE_REASONS	DCR	Change Reasons
P2K_CM_CHANGE_REASON_USAGES	DCRU
P2K_CM_CITIES	DCI	Cities (for taxation)
P2K_CM_COORDINATORS	DCOR	Co-ordinators
P2K_CM_COST_CENTERS	DCC	Cost Centers
P2K_CM_COST_CENTER_SECURITIES	DCCS
P2K_CM_COUNTIES	DCN	Counties
P2K_CM_COUNTRIES	DCO	Countries around the world
P2K_CM_DEPARTMENTS	DDP	Department code and standing.
P2K_CM_DEPARTMENT_DETAILS	DDD	Date sensitive department information.
P2K_CM_DISTRIBUTIONS	DDS	Rules for splitting dollars to different distr cod
P2K_CM_EMPLOYMENT_STATUSES	DES	Defines Work Status Codes.
P2K_CM_ENTITIES	DEN	A legal entity registered with the government.
P2K_CM_ENTITY_DETAILS	DED	Date sensitive details about an entity.
P2K_CM_FORM_DEFINITIONS	DFD	Form Definitions
P2K_CM_FORM_FIELDS	DFDF	Form Fields
P2K_CM_FORM_VARIABLES	DFDV	Form Variables
P2K_CM_GL_ACCOUNTS	DGA	Information about all the GL Accounts.
P2K_CM_GL_COMPANIES	DGC	Used to roll GL entries to.
P2K_CM_GL_FUNDS	DGF
P2K_CM_GL_FUND_DETAILS	DGFD
P2K_CM_GL_FUND_ELEMENTS	DGFE
P2K_CM_GL_SEGMENTS	DGS	Breakdown of GL Distribution code
P2K_CM_GL_SEGMENT_VALUES	DGSV	Gl Segment Values
P2K_CM_GOVT_RATES	DGT	Govt Rates
P2K_CM_GOVT_RATE_DETAILS	DGTD	Date sensistive registration details.
P2K_CM_GOVT_REGISTRATIONS	DGV	Government Registration Number and Type.
P2K_CM_GOVT_REGIST_SETS	DGVS	Govt Regist Sets
P2K_CM_GROUPS	DGR	Header for Group Details
P2K_CM_GROUP_DETAILS	DGD	Date Sensitive Group information.
P2K_CM_GROUP_ELEMENTS	DGRE	Group Elements
P2K_CM_HOLIDAY_CALENDARS	DHC	Header for Holiday Calendar Details.
P2K_CM_HOLIDAY_DETAILS	DHD	Holidays Information
P2K_CM_INDUSTRIES	DIN	Industries
P2K_CM_INTERFACE_FIELDS	DIFD	Interface Fields
P2K_CM_INTERFACE_FORMATS	DIF	Interface Formats
P2K_CM_JOBS	DJB	Header for Job Details
P2K_CM_JOB_DETAILS	DJD	Date Sensitive information for a job.
P2K_CM_JOB_SKILLS	DJS
P2K_CM_LOADED_GEOCODES	DLG	Loaded Geocodes
P2K_CM_LOCATIONS	DLN	Location information
P2K_CM_MUNICIPALITIES	DMN	Municipalities (for taxation)
P2K_CM_OCCUPATIONS	DOC	Occupations
P2K_CM_ORG_LEVELS	DOL	The various organization levels.
P2K_CM_ORG_LEVEL_DETAILS	DOLD	Which departments apply to which organization leve
P2K_CM_POSITIONS	DPS	Stores the position info that does not change over
P2K_CM_POSITION_DETAILS	DPD	Holds Date Effective information about a position.
P2K_CM_SCHOOL_DISTRICTS	DSD	All school district names and codes.
P2K_CM_STATE_PROVINCES	DSP	States and provinces around the world
P2K_CM_STATISTIC_COMPONENTS	DSC	Statistic Components
P2K_CM_TAX_JURISDICTIONS	DTX	Geographical areas
P2K_CM_TERMINATION_REASONS	DTR	Termination Reasons
P2K_CM_TIME_CODES	DTC	Time Codes
P2K_CM_TIME_CODE_SETS	DTCS	A component of a product - can be screens, report
P2K_CM_TIME_CODE_SET_DETAILS	DTCD	A component of a product - can be screens, report
P2K_CM_UNITS	DUN	Header for Unit Details.
P2K_CM_UNIT_DETAILS	DUD	Contract specific information.
P2K_CM_WORK_CALENDARS	DWC	Work Calendars
P2K_CM_WORK_CALENDAR_DETAILS	DWCD	Work Calendar Details
P2K_CM_WORK_RULES	DWR	Additional rules tied to group.
P2K_CM_WORK_RULE_DETAILS	DWRD	Hours per specific day of a period
P2K_CM_WORK_RULE_TIME_CODES	DWRC	Work Rule Time Codes
P2K_CM_WORK_TIME_RULES	DWT	Work Time Rules
P2K_CM_ZIP_RANGES	DZR	Zip Ranges

Notes #

Click to create a new notes page