GPSC_ELM_PR_DTL

(SQL View)
 Index Back

Process List Details

Process List Details

SELECT PIN_NUM , EFFDT , SEQ_NUM5 , ENTRY_TYPE_COND , PIN_COND_NUM , PIN_SECT_NUM FROM PS_GP_PROCESS_DTL WHERE NOT EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN) UNION SELECT PIN_NUM , EFFDT , SEQ_NUM5 , ENTRY_TYPE_COND , PIN_COND_NUM , PIN_SECT_NUM FROM PS_GPSC_RM_PR_DTL WHERE EXISTS ( SELECT 'X' FROM PS_GPSC_RM_PIN)

  • Parent record: GPSC_ELM_PRCS

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    2 EFFDT Date(10) DATE Effective Date
    3 SEQ_NUM5 Number(5,0) INTEGER NOT NULL Sequence Number
    4 ENTRY_TYPE_COND Character(3) VARCHAR2(3) NOT NULL Entry (element) type field

    Prompt Table: GP_ENT_COND_VW

    5 PIN_COND_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: %GP_EDIT_FLD1

    6 PIN_SECT_NUM Number(8,0) INTEGER NOT NULL Element number field

    Prompt Table: %RECNAME_EDIT2