CT_POLICY_HIST Table - Data Element Index


			<< go back

Select a data element to view its definition and its indexed, format, and null values.

Data element	Definition
HIST_KEY Indexed - yes Format - number May be null? no	Unique system-assigned key that identifies an historical policy record.
IS_DELETED Indexed - no Format - char(1) May be null? yes	Indicates whether the policy record has been deleted from Concur.
LAST_MODIFIED Indexed - no Format - date May be null? yes	Date on which the policy history record was last updated.
POL_KEY Indexed - yes Format - number May be null? no	Unique system-assigned key that identifies an expense policy record.
PROCESS_KEY Indexed - yes Format - number May be null? yes
SYSTEM_RECORD Indexed - no Format - char(1) May be null? yes

Questions about this page? Email us at da-staff@isc.upenn.edu