MONI_INF_BRA

(SQL Table)
 Index Back

Monitoring Results

Monitoring Results

  • Parent record: MED_ASO_H_BRA

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 PPP_EXAM_TYPE_BRA Character(1) VARCHAR2(1) NOT NULL PPP Exam Type
    A=New Hire
    D=Termination
    M=Job/Position Change
    P=Periodical according to PCMSO
    R=Return to Work
    3 ASO_DT_BRA Date(10) DATE NOT NULL ASO date.
    4 AGENT_CD_BRA Character(2) VARCHAR2(2) NOT NULL Agent Code

    Prompt Table: AGENT_BRA_VW

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

    Prompt Table: ANALY_BRA_VW

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

    Prompt Table: BIOLOGI_BRA_VW

    7 EXC_MONIT_BRA Character(1) VARCHAR2(1) NOT NULL Excessive Exposition
    N=No
    Y=Yes
    8 ORD_MONIT_BRA Character(1) VARCHAR2(1) NOT NULL Test Range
    0=Not Applicable
    1=Referential
    2=Sequential
    9 IND_MONIT_BRA Character(1) VARCHAR2(1) NOT NULL Test Result
    1=Normal
    2=Modified
    3=Stable
    4=Aggravation
    5=Occupational
    6=Not Occupational