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 |