GVT_PAMSYSCTLVW

(SQL View)
 Index Back

PAM SPS system control

PAM / SPS system control

SELECT A.GVT_SCHED_CODE , C.xlatlongname , A.DESCR , D.xlatshortname , E.xlatshortname , A.GVT_SCHED_MAX_TB , A.GVT_PYMNT_MAX_TB , A.GVT_MAX_AMT_TB , B.GVT_LAST_FILE_SEQ , B.GVT_INPUT_SYSTEM FROM ps_gvt_pam_sys_ctl A , ps_gvt_pam_user_dt B , XLATTABLE_VW C , XLATTABLE_VW D , XLATTABLE_VW E WHERE A.GVT_SCHED_CODE = B.GVT_SCHED_CODE AND C.eff_status = 'A' AND C.fieldname = 'GVT_SCHED_CODE' AND C.fieldvalue = A.GVT_SCHED_CODE AND D.eff_status = 'A' AND D.fieldname = 'GVT_ECS_PYMNT_1' AND D.fieldvalue = A.GVT_ECS_PYMNT_1 AND E.eff_status = 'A' AND E.fieldname = 'GVT_ECS_PYMNT_2' AND E.fieldvalue = A.GVT_ECS_PYMNT_2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GVT_SCHED_CODE Character(1) VARCHAR2(1) NOT NULL Schedule Code identifies PeopleSoft supported schedules and it is middle part of the Schedule Number. Schedule Number uniquely identifies each schedule and it is combination of Schedule Prefix, Schedule Code and Schedule Sequence.
A=PAMSALCHK
B=PAMSALEFT
C=PAMMISCHK
D=PAMMISEFT
2 DESCR15 Character(15) VARCHAR2(15) NOT NULL Short Description
3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
4 DESCRSHORT1 Character(10) VARCHAR2(10) NOT NULL Descr Short One
5 DESCRSHORT2 Character(10) VARCHAR2(10) NOT NULL Descr Short 2
6 GVT_SCHED_MAX_TB Number(5,0) INTEGER NOT NULL Maximum number of unique TAS BETC combinations per schedule
7 GVT_PYMNT_MAX_TB Number(3,0) SMALLINT NOT NULL Maximum number of unique TAS BETC combinations per payment
8 GVT_MAX_AMT_TB Signed Number(15,2) DECIMAL(13,2) NOT NULL Maximum amount per one TAS BETC
9 GVT_LAST_FILE_SEQ Number(4,0) SMALLINT NOT NULL Last File Sequence No to be used as part of the bulk file name
10 GVT_INPUT_SYSTEM Character(40) VARCHAR2(40) NOT NULL Input System (Agency ID + Payment Type 1 + Payment Type 2)