GPSC_ELM_SY

(SQL View)
 Index Back

System PIN Details

System PIN Details

SELECT PIN_NUM , SYSPIN_SRC , RECNAME , FIELDNAME , SYSPIN_SETID_IND , PROMPTVIEW , PIN_SETID_NUM , CHART_FLD_IND , EVAL_GRP_ID , GP_VERSION FROM PS_GP_SYSTEM_PIN WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , SYSPIN_SRC , RECNAME , FIELDNAME , SYSPIN_SETID_IND , PROMPTVIEW , PIN_SETID_NUM , CHART_FLD_IND , EVAL_GRP_ID , GP_VERSION FROM PS_GPSC_RM_SYS_PIN 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 SYSPIN_SRC Character(1) VARCHAR2(1) NOT NULL System Element Source
D=Database Field
S=System-Computed
3 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

Prompt Table: GP_PSRECDEFN_VW

4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

Prompt Table: GP_PSRECFIELDVW

5 SYSPIN_SETID_IND Character(1) VARCHAR2(1) NOT NULL SetID Controlled

Y/N Table Edit

6 PROMPTVIEW Character(18) VARCHAR2(18) NOT NULL Element Entry Prompt View

Prompt Table: GP_PSRECDEFN_VW

7 PIN_SETID_NUM Number(8,0) INTEGER NOT NULL Element number field

Prompt Table: GP_PIN_SY5_VW

8 CHART_FLD_IND Character(1) VARCHAR2(1) NOT NULL Indicates whether an element can be used as chart field (Y/N)

Y/N Table Edit

9 EVAL_GRP_ID Character(5) VARCHAR2(5) NOT NULL Evaluate Group ID
10 GP_VERSION Character(18) VARCHAR2(18) NOT NULL Stores element version.