This is version 1 2 3 4 5 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

Alias: CDA#

(P2K_CP_DEVELOPMENT_ACTIVITIES)

Unique Keys:
Child Table:
Parent Table:
ERD: ERD-CP03

Development Activities

Table Columns#

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
CRS_ID	Number(10)	ID		link to P2K_CP_COURSES
CDP_ID	Number(10)	ID		link to P2K_CP_DEVELOPMENT_PROGRAMS
RCA_ID	Number(10)	ID		link to P2K_RE_CANDIDATES
CDPS_ID	Number(10)	ID		link to P2K_CP_PROGRAM_STEPS
RAS_ID	Number(10)	ID		link to P2K_RE_ASSESSMENTS
ACTIVITY_SEQUENCE	Number(5)	NUMBER5	Y
ACTIVITY_STATUS	Varchar2(2)	X_ACTIVITY_STATUS	Y
APPROVED	Varchar2(1)	TOGGLE
ACTIVITY_TYPE	Varchar2(2)	X_ACTIVITY_TYPE
ACTIVITY_CATEGORY	Varchar2(2)	X_ACTIVITY_CATEGORY
DESCRIPTION	Varchar2(50)	DESCRIPTION
ACTIVITY_START_DATE	Date()	DATE
ACTIVITY_END_DATE	Date()	DATE
DURATION	Number(9)	AMT5V4
DURATION_BASIS	Varchar2(2)	X_PERIOD_BASIS
BUDGET_AMOUNT	Number(18)	AMT12V6
ACTUAL_AMOUNT	Number(18)	AMT12V6
CURRENCY	Varchar2(2)	X_CURRENCY
ACTIVITY_TEXT	Varchar2(4000)	VARCHAR4000
COMPETENCY_RATING	Varchar2(2)	X_COMPETENCY_RATING
DESIGNATED_SUCCESSOR	Varchar2(1)	TOGGLE
LOSS_IMPACT	Varchar2(1)	TOGGLE
PLAN_POTENTIAL	Varchar2(1)	TOGGLE
SUCCESSION_READINESS	Varchar2(2)	X_SUCCESSION_READINESS
SUCCESSION_RANKING	Number(5)	TOGGLE
SUCCESSION_STATUS	Varchar2(2)	X_SUCCESSION_STATUS

CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y

Derived Fields#

Column Name
DRV_APPROVAL_BAR

User Fields: Allowed
Audit Logging: Allowed

---

Notes #

Click to create a new notes page