GPUS_NRP_GRL_VW

(SQL View)
 Index Back

GPUS_GARNISH

GPUS_GARNISH

SELECT GPUS_GRN_ID , EMPLID , GPUS_RLAWSRC , GPUS_PIN_PROFM_NUM + 50000000 , GPUS_PIN_LMCAL_NUM + 50000000 , GPUS_PIN_LMCF_NUM + 50000000 , GPUS_PIN_LMPF_NUM + 50000000 , LANGUAGE_CD , GPUS_AGENCYNM , GPUS_ATTRNYNM , COUNTRY , ADDRESS1 , ADDRESS2 , ADDRESS3 , ADDRESS4 , CITY , NUM1 , NUM2 , HOUSE_TYPE , ADDR_FIELD1 , ADDR_FIELD2 , ADDR_FIELD3 , COUNTY , STATE , POSTAL , GEO_CODE , IN_CITY_LIMIT , CONTACT_NAME , PHONE , EMAILID , GPUS_REMARKS FROM PS_GPUS_GRN_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GPUS_GRN_ID Character(16) VARCHAR2(16) NOT NULL GPUS_GARNID
2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
3 GPUS_RLAWSRC Character(6) VARCHAR2(6) NOT NULL GPUS_LAWSRC
4 GPUS_PIN_PROFM_NUM Number(8,0) INTEGER NOT NULL Proration Formula PIN Number
5 GPUS_PIN_LMCAL_NUM Number(8,0) INTEGER NOT NULL Limit Calculation Formula PIN Number
6 GPUS_PIN_LMCF_NUM Number(8,0) INTEGER NOT NULL Limit Company Fee PIN Number
7 GPUS_PIN_LMPF_NUM Number(8,0) INTEGER NOT NULL Limit Payee Fee PIN Number
8 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
9 GPUS_AGENCYNM Character(60) VARCHAR2(60) NOT NULL Agency Name
10 GPUS_ATTRNYNM Character(50) VARCHAR2(50) NOT NULL Attroney Name
11 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country

Prompt Table: SCC_CNT_ADFMTVW

12 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
13 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
14 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
15 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
16 CITY Character(30) VARCHAR2(30) NOT NULL City
17 NUM1 Character(6) VARCHAR2(6) NOT NULL Number 1
18 NUM2 Character(6) VARCHAR2(6) NOT NULL Number 2
19 HOUSE_TYPE Character(2) VARCHAR2(2) NOT NULL House Type
AB=House Boat Reference
WW=House Trailer Reference
20 ADDR_FIELD1 Character(2) VARCHAR2(2) NOT NULL Address Field 1
21 ADDR_FIELD2 Character(4) VARCHAR2(4) NOT NULL Address Field 2
22 ADDR_FIELD3 Character(4) VARCHAR2(4) NOT NULL Address Field 3
23 COUNTY Character(30) VARCHAR2(30) NOT NULL County
24 STATE Character(6) VARCHAR2(6) NOT NULL State

Prompt Table: STATE_TBL

25 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
26 GEO_CODE Character(11) VARCHAR2(11) NOT NULL Geo Code
27 IN_CITY_LIMIT Character(1) VARCHAR2(1) NOT NULL In City Limit

Y/N Table Edit

28 CONTACT_NAME Character(50) VARCHAR2(50) NOT NULL Contact Name
29 PHONE Character(24) VARCHAR2(24) NOT NULL Telephone
30 EMAILID Character(70) VARCHAR2(70) NOT NULL A user's E-mail address
31 GPUS_REMARKS Long Character CLOB GPUS_REMARKS