GPSC_ELM_WA

(SQL View)
 Index Back

Main Writeable Array Record

This is the main Writeable Array Definition Table.

SELECT PIN_NUM , RECNAME , BULK_INSERT , GP_VERSION FROM PS_GP_WA_ARRAY WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , RECNAME , BULK_INSERT , GP_VERSION FROM PS_GPSC_RM_WA_AR WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: GP_WAREC_VW

3 BULK_INSERT Character(1) VARCHAR2(1) NOT NULL Bulk Insert Flag

Y/N Table Edit

4 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.