PRM_RESOURCEASSIGNMENT |
Default Table Name | PRM_RESOURCEASSIGNMENT |
Definition |
PRM_RESOURCEASSIGNMENT Columns |
ColumnName | Domain | Datatype | NULL | Definition |
UPLOAD_ID | VARCHAR2(36) | YES | ||
ACTIVITYOBJECTID | VARCHAR2(255) | YES | ||
ACTUALCOST | VARCHAR2(255) | YES | ||
ACTUALFINISHDATE | VARCHAR2(255) | YES | ||
ACTUALOVERTIMECOST | VARCHAR2(255) | YES | ||
ACTUALOVERTIMEUNITS | VARCHAR2(255) | YES | ||
ACTUALREGULARCOST | VARCHAR2(255) | YES | ||
ACTUALREGULARUNITS | VARCHAR2(255) | YES | ||
ACTUALSTARTDATE | VARCHAR2(255) | YES | ||
ACTUALTHISPERIODCOST | VARCHAR2(255) | YES | ||
ACTUALTHISPERIODUNITS | VARCHAR2(255) | YES | ||
ACTUALUNITS | VARCHAR2(255) | YES | ||
ATCOMPLETIONCOST | VARCHAR2(255) | YES | ||
ATCOMPLETIONUNITS | VARCHAR2(255) | YES | ||
COSTACCOUNTOBJECTID | VARCHAR2(255) | YES | ||
DRIVINGACTIVITYDATESFLAG | VARCHAR2(255) | YES | ||
FINISHDATE | VARCHAR2(255) | YES | ||
GUID | VARCHAR2(255) | YES | ||
ISCOSTUNITSLINKED | VARCHAR2(255) | YES | ||
OBJECTID | VARCHAR2(255) | YES | ||
OVERTIMEFACTOR | VARCHAR2(255) | YES | ||
PENDINGACTUALOVERTIMEUNITS | VARCHAR2(255) | YES | ||
PENDINGACTUALREGULARUNITS | VARCHAR2(255) | YES | ||
PENDINGPERCENTCOMPLETE | VARCHAR2(255) | YES | ||
PENDINGREMAININGUNITS | VARCHAR2(255) | YES | ||
PLANNEDCOST | VARCHAR2(255) | YES | ||
PLANNEDDURATION | VARCHAR2(255) | YES | ||
PLANNEDFINISHDATE | VARCHAR2(255) | YES | ||
PLANNEDLAG | VARCHAR2(255) | YES | ||
PLANNEDSTARTDATE | VARCHAR2(255) | YES | ||
PLANNEDUNITS | VARCHAR2(255) | YES | ||
PLANNEDUNITSPERTIME | VARCHAR2(255) | YES | ||
PRICEPERUNIT | VARCHAR2(255) | YES | ||
PROFICIENCY | VARCHAR2(255) | YES | ||
RATESOURCE | VARCHAR2(255) | YES | ||
RATETYPE | VARCHAR2(255) | YES | ||
REMAININGCOST | VARCHAR2(255) | YES | ||
REMAININGDURATION | VARCHAR2(255) | YES | ||
REMAININGFINISHDATE | VARCHAR2(255) | YES | ||
REMAININGLAG | VARCHAR2(255) | YES | ||
REMAININGSTARTDATE | VARCHAR2(255) | YES | ||
REMAININGUNITS | VARCHAR2(255) | YES | ||
REMAININGUNITSPERTIME | VARCHAR2(255) | YES | ||
RESOURCECURVEOBJECTID | VARCHAR2(255) | YES | ||
RESOURCEOBJECTID | VARCHAR2(255) | YES | ||
RESOURCETYPE | VARCHAR2(255) | YES | ||
ROLEOBJECTID | VARCHAR2(255) | YES | ||
STARTDATE | VARCHAR2(255) | YES | ||
UNITSPERCENTCOMPLETE | VARCHAR2(255) | YES | ||
RESOURCEREQUEST | VARCHAR2(255) | YES |
PRM_RESOURCEASSIGNMENT Primary and Unique Keys |
Key Name | Key Type | Keys |
PRM_RESOURCEASSIGNMENT Foreign Keys |
Parent Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Deferrable | Initially Deferred |
Child Relationships: |
Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Deferrable | Initially Deferred |