rfs Table: Application Field Security

Database Reference Sybase DBMS

rfs Table: Application Field Security

Indexes

Name	Segment 1
rfs_idx0	fsec_cd_s

Columns
Name	Description	Datatype ¿?	Allow Null
fsec_cd_s	Field security code	char(4)	no
timestamp	Record modification stamp	timestamp	yes
updt1_s	Allow update (Y/N/T) Y - application field may be modified N - application field may not be modified T - application field may be modified within certain tolerance percent or amount of the approved application value	char(200)	yes
updt2_s	Allow update (Y/N/T)	char(200)	yes
updt3_s	Allow update (Y/N/T)	char(200)	yes
fsec_desc_s	Field security description	char(20)	yes
p_tolpct1_d	Percent tolerance of approved application value [1]	double precision	yes
p_tolpct2_d	Percent tolerance of approved application value [2]	double precision	yes
p_tolpct3_d	Percent tolerance of approved application value [3]	double precision	yes
p_tolpct4_d	Percent tolerance of approved application value [4]	double precision	yes
p_tolpct5_d	Percent tolerance of approved application value [5]	double precision	yes
p_tolpct6_d	Percent tolerance of approved application value [6]	double precision	yes
p_tolpct7_d	Percent tolerance of approved application value [7]	double precision	yes
p_tolpct8_d	Percent tolerance of approved application value [8]	double precision	yes
p_tolpct9_d	Percent tolerance of approved application value [9]	double precision	yes
p_tolpct10_d	Percent tolerance of approved application value [10]	double precision	yes
p_tolpct11_d	Percent tolerance of approved application value [11]	double precision	yes
p_tolpct12_d	Percent tolerance of approved application value [12]	double precision	yes
p_tolpct13_d	Percent tolerance of approved application value [13]	double precision	yes
p_tolpct14_d	Percent tolerance of approved application value [14]	double precision	yes
p_tolpct15_d	Percent tolerance of approved application value [15]	double precision	yes
p_tolpct16_d	Percent tolerance of approved application value [16]	double precision	yes
p_tolpct17_d	Percent tolerance of approved application value [17]	double precision	yes
p_tolpct18_d	Percent tolerance of approved application value [18]	double precision	yes
p_tolpct19_d	Percent tolerance of approved application value [19]	double precision	yes
p_tolpct20_d	Percent tolerance of approved application value [20]	double precision	yes
tolamt1_l	Tolerance amount allowed to exceed approved value [1]	integer	yes
tolamt2_l	Tolerance amount allowed to exceed approved value [2]	integer	yes
tolamt3_l	Tolerance amount allowed to exceed approved value [3]	integer	yes
tolamt4_l	Tolerance amount allowed to exceed approved value [4]	integer	yes
tolamt5_l	Tolerance amount allowed to exceed approved value [5]	integer	yes
tolamt6_l	Tolerance amount allowed to exceed approved value [6]	integer	yes
tolamt7_l	Tolerance amount allowed to exceed approved value [7]	integer	yes
tolamt8_l	Tolerance amount allowed to exceed approved value [8]	integer	yes
tolamt9_l	Tolerance amount allowed to exceed approved value [9]	integer	yes
tolamt10_l	Tolerance amount allowed to exceed approved value [10]	integer	yes
tolamt11_l	Tolerance amount allowed to exceed approved value [11]	integer	yes
tolamt12_l	Tolerance amount allowed to exceed approved value [12]	integer	yes
tolamt13_l	Tolerance amount allowed to exceed approved value [13]	integer	yes
tolamt14_l	Tolerance amount allowed to exceed approved value [14]	integer	yes
tolamt15_l	Tolerance amount allowed to exceed approved value [15]	integer	yes
tolamt16_l	Tolerance amount allowed to exceed approved value [16]	integer	yes
tolamt17_l	Tolerance amount allowed to exceed approved value [17]	integer	yes
tolamt18_l	Tolerance amount allowed to exceed approved value [18]	integer	yes
tolamt19_l	Tolerance amount allowed to exceed approved value [19]	integer	yes
tolamt20_l	Tolerance amount allowed to exceed approved value [20]	integer	yes
hilight1_s	Highlighted field	char(200)	yes
hilight2_s	Highlighted field	char(200)	yes
hilight3_s	Highlighted field	char(200)	yes