sgrRetornaPF
Returns the professional profile data (Opentech register).
PARAMETERS
| Field | Type | Req | Description |
|---|---|---|---|
| keyaccess | string | Yes | Key returned by the sgrLogin method. |
| cdpas | integer | Yes | PAS code, returned by the sgrListaPASUsuario method |
| cdCountryOrigin | integer | Yes | Country of origin code, returned by the sgrListCountry method. |
| nrDocumento | string | Yes | Professional's document number (CPF). |
| cdcli | integer | Yes | Client code, returned by the sgrListaEmpresasUsuario method. |
METHOD RETURN:
ReturnDataset: If the parameters are correct, the property will be composed of the following tables: sgrPessoaFisica, sgrRefPessoais, sgrRefBancaria and sgrFoto.
sgrPessoaFisica:
| Field | Type | Description |
|---|---|---|
| CDPFJ | integer | Professional profile code |
| CDUFCNH | integer | CNH issuing UF code |
| NRCNH | string | CNH number |
| DSCATCNH | string | CNH category |
| NRREGISCNH | string | CNH registration number |
| DTEMISCNH | datetime | CNH issue date |
| DTVCTOCNH | datetime | CNH expiration date |
| DTVCTOMOOP | datetime | MOPP expiration date |
| FLTIPOPESSOA | integer | Type of Person |
| NRCGCCPF | string | CPF number |
| DSNOME | string | Name |
| SURNAME | string | Professional's surname |
| DSStreet | string | Address |
| DSBAIRRO | string | Address Neighborhood |
| NRRUA | string | Address Number |
| DSCOMPLRUA | string | Address Complement |
| NRCEP | string | Zip Code |
| CDCID | integer | City code |
| NRFONE1 | string | Phone number 1 |
| NRFONE2 | string | Phone number 2 |
| NRFAX | string | Fax number |
| DSEMAIL | string | |
| NRIDENT | string | ID number |
| CDORGAEMISRG | integer | ID Issuing Body Code |
| DTEXPED | datetime | Date of issue of ID card |
| CDPROFIS | integer | Profession code |
| DTNASC | datetime | Date of birth |
| FLSEXO | char(1) | Sex |
| DSPAI | string | Father's name |
| DSMAE | string | Mother's name |
| CDESTCIVIL | integer | Marital Status Code |
| DSCONJUJE | string | Spouse's Name |
| FLSITRESID | integer | Residence Status |
| NRANORESID | integer | Number of years of residence at address |
| NRMESRESID | integer | Number of months living at address |
| CDPAISNAC | integer | Country of Nationality Code |
| DSPAISNATIONALITY | string | Name of country of nationality |
| NATURALITY | integer | City of birth code |
| DSCIDADENATURALITY | string | Name of city of birth |
| FLVINCULO | string | PF's relationship with the company |
| VLLAT | float | Latitude of address |
| VLLONG | float | Longitude of address |
| CDOP | integer | Opentech internal use |
| DSESTADOCNH | string | CNH issuing state |
| DSNOMECURTO | string | Name of the CNH issuing body |
| DSPROFIS | string | Individual's profession |
| DSESTCIVIL | string | Marital status |
| DSSITRESID | string | Residence status |
| CIDADEENDERECO | string | City of residence |
| DSORGAOEMISSRG | string | Name of ID issuing body |
| DTVCTOASO | datetime | ASO expiration date |
| DTVCTOREC | datetime | Recycling due date |
| DTVCTOPSI | datetime | Psychotechnic due date |
| NRMOPP | string | MOPP number |
| CDENTIDADEMOPP | integer | MOPP registration entity code |
| DSENTIDADEMOPP | string | Name of MOPP registration entity |
| NRMATRICULACLIENT | string | Company registration number (employee) |
| DTCONTRATACAOCLIENTE | datetime | Date the individual was hired by the company |
| CDOPERACAO | integer | Individual's operation code in the company |
| DSOPERATION | string | Operation description |
| CDUNIDADERESP | integer | Code of the unit responsible for the individual |
| DSUNIDADERESP | string | Unit Description |
| NRRNTRC | string | ANTT registration number |
| DTVALIDADERNTRC | date | ANTT registration validity date |
| nrDD1 | string | phone DDD 1 |
| nrDD2 | string | DDD of phone 2 |
| nrDDDFax | string | FAX DDD |
sgrRefPersonnel
| Field | Type | Description |
|---|---|---|
| CDREFPES | integer | Personal reference code |
| DSNAME | string | Personal reference name |
| DSBAIRRO | string | Name of personal reference's address neighborhood |
| DSRUA | string | Personal reference's address |
| NRSTREET | string | address number |
| DSCOMPLRUA | string | Address complement |
| NRCEP | string | ZIP code of address |
| CDTIPORELAC | integer | Relationship type |
| CDCID | integer | Personal reference address city code |
| NRFONE1 | string | Phone number 1 of the personal reference |
| NRFONE2 | string | Phone number 2 of the personal reference |
| DTINCLUSION | string | Personal reference's inclusion date |
| DSCITY | string | City of reference |
| DSTIPORELAC | string | Relationship type description |
| nrDD1 | string | DDD number of phone number 1 of the personal reference |
| nrDD2 | string | DDD number of phone 2 of personal reference |
sgrRefBanking
| Field | Type | Description |
|---|---|---|
| CDCONTABANCO | integer | Account code |
| NRBANK | string | Bank number |
| NRAGENCY | string | Branch number |
| NRCC | string | Current account number |
| CDBANCO | integer | Bank code |
| DSBANCO | string | Bank name |
sgrPhoto:
| Field | Type | Description |
|---|---|---|
| CDPFJ | integer | Professional profile code |
| CDOP | integer | Operator code (Opentech internal use) |
| BLFOTO | blob | Photo |
ReturnDescription: If there is an error when executing the method, the property will display:
| Error | Description |
|---|---|
| The CPF or CNPJ entered is invalid The document format entered is invalid. | You must enter it again. |
| CPF Not Registered | Follow the steps in the DRIVER CONSULTATION AND REGISTRATION |