DPA_BAMSPEC_HDR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	DP_CONFIGVIEW	Character(20)	VARCHAR2(20) NOT NULL	DP_CONFIGVIEW Prompt Table: DP_VIEW1USER_VW
3	DP_BAMSPEC	Character(20)	VARCHAR2(20) NOT NULL	specification used for defining BAM queries / reports
4	DP_CAPTION	Character(30)	VARCHAR2(30) NOT NULL	DP_CAPTION
5	DP_PUBLISHNAME	Character(20)	VARCHAR2(20) NOT NULL	Publish Name Prompt Table: DP_PUB_FC_VW
6	DP_INHIBITED_OPT	Character(1)	VARCHAR2(1) NOT NULL	options for selecting INHIBITED FC items from the PUB tables 0=Exclude 1=Include 2=Ignore Default Value: 0
7	DP_SUSPENDED_OPT	Character(1)	VARCHAR2(1) NOT NULL	options for selecting SUSPENDED items from the PUB tables 0=Exclude 1=Include 2=Ignore Default Value: 0
8	DP_FC_INTERVAL	Character(1)	VARCHAR2(1) NOT NULL	time interval used to summarize and report FC information in BAM values include: daily, weekly, monthly, quarterly 1=Daily 2=Weekly 3=Monthly 4=Quarterly Default Value: 1
9	DP_MOD_DATE	DateTime(26)	TIMESTAMP	date modified - used to track record changes
10	DP_MODIFIEDBY	Character(20)	VARCHAR2(20) NOT NULL	DP_MODIFIEDBY
11	DP_BAM_RPT_TITLE	Character(36)	VARCHAR2(36) NOT NULL	BAM Smart View report title
12	DP_ROW_LIMIT	Number(8,0)	INTEGER NOT NULL	set a limit on number of rows returned from a query Default Value: 20000