MONI_RESP_BRA

(SQL Table)
Index Back

Monitoring Responsible

Monitoring Responsible

  • 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 ASO date.
    4 PHYSICIAN_ID Character(11) VARCHAR2(11) NOT NULL Physician ID

    Prompt Table: PHYSICIAN_SRCH

    5 PHYSICIAN_NAME Character(50) VARCHAR2(50) NOT NULL Physician Name
    6 MED_CRM_BRA Character(15) VARCHAR2(15) NOT NULL Medical Certication Register.
    7 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

    Default Value: BRA

    8 STATE_MON_BRA Character(6) VARCHAR2(6) NOT NULL State

    Prompt Table: STATE_TBL

    9 PIS_BRA Character(14) VARCHAR2(14) NOT NULL PIS / NIS Number