BIOLOGI_BRA_VW (SQL View)	Index Back
Biological Material - View Biological Material - View

BIOLOGI_BRA_VW

(SQL View)

Biological Material - View

SELECT A.AGENT_CD_BRA , A.ANALYS_CD_BRA , A.MATER_BIO_BRA , B.XLATLONGNAME FROM %Table(BIOLOGI_INF_BRA) A , %Table(XLATTABLE_VW) B WHERE %EffdtCheck(BIOLOGI_INF_BRA A1, A, %CURRENTDATEIN) AND B.FIELDNAME = 'MATER_BIO_BRA' AND B.FIELDVALUE = A.MATER_BIO_BRA AND %EffdtCheck(XLATTABLE_VW B1, B, %CURRENTDATEIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 AGENT_CD_BRA Character(2) VARCHAR2(2) NOT NULL Agent Code

2 ANALYS_CD_BRA Character(4) VARCHAR2(4) NOT NULL Analysis Code

3 MATER_BIO_BRA Character(1) VARCHAR2(1) NOT NULL Biological Material
0=Not Applicable
1=Urine
2=Blood

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	AGENT_CD_BRA	Character(2)	VARCHAR2(2) NOT NULL	Agent Code
2	ANALYS_CD_BRA	Character(4)	VARCHAR2(4) NOT NULL	Analysis Code
3	MATER_BIO_BRA	Character(1)	VARCHAR2(1) NOT NULL	Biological Material 0=Not Applicable 1=Urine 2=Blood
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description