More information

Actions Data Table

Profiles World Actions data is stored in the actions data table. The chart below describes the columns that are included in the actions data table. The column labels and non-displaying designations that are listed in the chart are those that the system uses by default.

In this chart, the lookup table names display as hyperlinks. Click the name to learn more about the lookup table. Click the Back button on the Help system's navigation toolbar to return to this topic.

Note: Custom fields are included in the data table, and are available for any purpose that you want to define. These fields are not shown on the standard Display or standard Data Maintenance forms. If you want to make use of one or more of the custom fields, use the Custom Display Designer to edit the standard Display and Data Maintenance forms.

Field Name Field Label	Lookup Table	Type SQL/Oracle Length [Default] {Check}	Description
actkey non-displaying	none	numeric/number 13,0	The primary key field for all rows in all tables. This field holds a permanent "time stamp" of the precise time and date the row was created. This uniquely identifies a row within the table. (System column)
actid non-displaying	none	char 10	This field holds the ID number of the constituent who owns this row, providing a link between this row and all others in all other tables which also belong to the same constituent. (System column)
actdoc non-displaying	none	char 1 ['N']	This field holds a Y/N flag to indicate the existence of a linked document for this row. (System column)
actdate no label	none	datetime/date [getdate()]	The date that this Actions row was last updated. This field is automatically entered by the system. (System column)
actuserid no label	none	varchar/varchar2 30 [suser_sname()]	The User ID of the operator that last edited this Actions row. It is automatically entered by the system. (System column)
actugroup non-displaying	none	char 1 ['Z']	This field holds the Group letter that was associated with the User ID of the operator who last edited this row. (System column)
actcompdat Completed On	none	datetime/date	This is the actual date of completion of this action. If more than one task is linked to this action, this date will be automatically populated with the date that the last task to be completed, was completed. If an additional task is added to the action after all other linked tasks have been completed, then this date must be manually updated with the completion date of this additional task.
actduedate Due Date	none	datetime/date	The date on which the action is due to be completed.
actlocatn Location	none	char 50	A description of the location where the action takes place, up to 50 characters.
actprior Priority	Priority	char 6 [' ']	The priority assigned to the action.
actdivis Division	Division	char 6 [' ']	The division within the institution that is responsible for the action. The values for this list come from the Divisions lookup table.
acttype Type	Action Types	char 6 [' ']	The action category associated with the action. The list values are defined in the Action Types lookup table.
actrelfil non-displaying	none	char 2	This field holds a copy of the file (table) number of the row to which this Action row is attached. (System column)
actrelkey non-displaying	none	numeric/number 13,0 [0]	This field holds a copy of the key field from the row to which this Action row is attached. (System column)
actcamp Campaign	Campaigns	char 6 [' ']	The campaign that is responsible for this action. The values for this field are defined in the Campaigns lookup table.
actcampyr Campaign Year	none	char 4	The year of the campaign associated with the action. This is a numeric value between 1600 and 2200.
actpoint non-displaying	none	numeric/number 10,0	This system-assigned field is no longer used or supported. (System column)
actsource Source	Source	char 6 [' ']	The source of the action, such as an organization or communication type. The values for this list come from the Source lookup table.
actcrdate non-displaying	none	datetime/date [getdate()]	The date that the row was created. (System column)
actfnum non-displaying	none	char 2 ['11'] {'11'}	The file (table) number for the Actions table. (System column)
actcomm no label	none	varchar/varchar2 4000	A free-text field up to 4000 characters that contains any supporting notes or comments about the action.
acttaskflg non-displaying	none	char 1	A flag telling the system whether there is or is not a Task linked (System column) to this Action row.
actcompflg non-displaying	none	char 1 ['N'] {'Y' or 'N'}	A flag indicating whether this Action has or has not been completed. It is automatically set to 'Y' when a completed date is entered in the actcompdat field. This field (actcompflg) is used to define a Sort involving non-completed Actions. (SQL treats blank datetime fields in such a way that simply sorting on the actcompdat field may not produce the desired results.) To display non-completed Actions at the top of the display, the Sort definition should begin with the actcompflg in ascending order. It may then be followed by any additional Sort criteria you want. (System column)
actdate1	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdate2	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actmny1	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny2	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actnum1	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum2	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actyesno	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actlook1	Actions Lookup1	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
actlook2	Actions Lookup2	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
actlook3	Actions Lookup3	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
acttext	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
actjntid non-displaying	none	char 10	This field holds a copy of the constituent ID Number for the constituent with whom this row is jointly linked. (System column)
actjntkey non-displaying	none	numeric/number 13,0 [0]	This field holds a copy of the key field from the row with which this Action row is jointly linked. (System column)
actdate3	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdate4	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdate5	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdate6	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdate7	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdate8	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdate9	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdte10	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdte11	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actdte12	none	datetime/date	This custom field may be defined and used by your institution to track any date information associated with this data row.
actmny3	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny4	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny5	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny6	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny7	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny8	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny9	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny10	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny11	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actmny12	none	money/number (19,4)/(16,2)	This custom field may be defined and used by your institution to track any monetary information associated with this data row.
actnum3	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum4	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum5	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum6	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum7	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum8	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum9	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum10	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum11	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actnum12	none	numeric/number 10, 0	This custom field may be defined and used by your institution to track any numeric information associated with this data row.
actchk1	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk2	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk3	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk4	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk5	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk6	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk7	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk8	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk9	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
actchk10	none	char 1 ['N'] {'N' or 'Y'}	This custom field may be defined and used by your institution to flag this data row for any purpose.
acttxt1	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt2	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt3	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt4	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt5	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt6	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt7	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt8	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt9	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
acttxt10	none	varchar/varchar2 255	This custom field may be defined and used by your institution to track any free text information you want to associate with this data row.
actlook4	Actions Lookup4	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
actlook5	Actions Lookup5	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.
actlook6	Actions Lookup6	char 6	This custom field may be defined and used by your institution to track any lookup table driven information associated with this data row.

Indices - Actions

Index	Primary	Foreign	Unique	Fields	Sort
pk_actions	Y		Y	actkey	ASC
actions02		Y		actid	ASC
actions03		Y		actdivis	ASC
actions04				actduedate	ASC
actions05		Y		actrelky1, actrelfil	ASC
actions06				actcompdat	DESC
actions07				actjntkey	ASC