RESPONS_VW_BRA

(SQL View)
Index Back

HS Responsible Search

Search record for Rsponsible Setup Panel.

SELECT B.ORG_STAT2_BRA ,A.RESPONSIBLE_ID ,A.NAME FROM PS_HA_RESPO_NA_BRA A , PS_HA_RESP_REG_BRA B WHERE A.RESPONSIBLE_ID = B.RESPONSIBLE_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ORG_STAT2_BRA Character(1) VARCHAR2(1) NOT NULL Organ Statutory Information
0=Not Applicable
1=CRM
4=CREA
9=Other
2 RESPONSIBLE_ID Character(11) VARCHAR2(11) NOT NULL Responsible ID
3 NAME Character(50) VARCHAR2(50) NOT NULL Name