XML_DLTCMP_VW

(SQL View)
 Index Back

ESP Delta Company Data

Company Data

SELECT A.COMPANY , A.EFFDT , A.EFF_STATUS , A.DESCR , A.COUNTRY , A.ADDRESS1 , A.ADDRESS2 , A.CITY , A.NUM1 , A.NUM2 , A.ADDR_FIELD1 , A.ADDR_FIELD2 , A.STATE , A.POSTAL , A.FISCAL_ID_CD , A.PHONE_TYPE , A.COUNTRY_CODE , A.PHONE , A.INSUR_COMP_CD_ESP , A.SSN_EMPLOYER , A.ESTABID , A.SSN_EMPL_TYPE , A.INDSTRY_CD_ESP , A.SCHEME_ID_ESP , B.DLT_PREVENTIVA_ESP FROM PS_COMPDATA_ESP_VW A , PS_SOCS_SETHD_ESP B WHERE A.COMPANY = B.COMPANY

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
2 EFFDT Date(10) DATE Effective Date

Default Value: %date

3 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive
4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
6 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
7 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
8 CITY Character(30) VARCHAR2(30) NOT NULL City
9 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
10 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
11 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
12 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
13 STATE Character(6) VARCHAR2(6) NOT NULL State
14 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
15 FISCAL_ID_CD Character(10) VARCHAR2(10) NOT NULL Fiscal Identification Code
16 PHONE_TYPE Character(4) VARCHAR2(4) NOT NULL Phone Type
BUSN=Business
CAMP=Campus
CELL=Mobile
DORM=Dormitory
FAX=FAX
HOME=Home
MAIN=Main
OTR=Other
PGR1=Pager 1
PGR2=Pager 2
TELX=Telex
WORK=Work
17 COUNTRY_CODE Character(3) VARCHAR2(3) NOT NULL Country Code
18 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
19 INSUR_COMP_CD_ESP Character(5) VARCHAR2(5) NOT NULL Insurance Company Code
20 SSN_EMPLOYER Character(13) VARCHAR2(13) NOT NULL Employer Social Security number
21 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
22 SSN_EMPL_TYPE Character(3) VARCHAR2(3) NOT NULL Social Security Number Type
1=Regular
2=Apprenticeship
3=Training
23 INDSTRY_CD_ESP Character(5) VARCHAR2(5) NOT NULL Industry Activity Code
24 SCHEME_ID_ESP Character(4) VARCHAR2(4) NOT NULL Scheme ID - ESP
25 DLT_PREVENTIVA_ESP Character(1) VARCHAR2(1) NOT NULL Preventive
A=Business Owner
E=External
I=Internal
M=Shared
N=None
W=Designed Workers