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 , 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 Company Fee Limit Formula PIN Number
7 GPUS_PIN_LMPF_NUM Number(8,0) INTEGER NOT NULL Recipient Fee Limit Formula 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 GPUS_REMARKS Long Character CLOB GPUS_REMARKS