GPCH_EG_DLGRSP

(SQL Table)
Index Back

GetDialog response

Record for capturing getdialog response.

  • Parent record: GPCH_EG_PSTATUS
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company
    2 GPCH_RC_PAY_YEAR Number(4,0) SMALLINT NOT NULL Pay Year
    3 GPCH_EG_DOMAINID Number(3,0) SMALLINT NOT NULL Domain Set ID for the ELM Domain Sets
    4 GPCH_EG_REQUEST_ID Character(30) VARCHAR2(30) NOT NULL Holds Request ID in the ELM File
    5 GPCH_SI_PROV_TYPE Character(1) VARCHAR2(1) NOT NULL Provider Type
    0=Identify
    1=Others
    2=UVG-LAA
    3=KTG-AMC
    4=UVGZ-LAAC
    5=FAK-CAF
    6=BVG-LPP
    7=AHV-AVS
    8=LAW-CDS
    9=BFS-OFS
    A=QST-IS
    B=Write File
    C=Base AL08
    D=GRFI-FRFI
    E=EO-APG
    I=BNK_BNQ
    6 GPCH_SI_PROV_CD Character(6) VARCHAR2(6) NOT NULL Provider Code
    7 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    8 GPCH_EG_DLG_TYPE Character(10) VARCHAR2(10) NOT NULL Dialog Response ID
    9 GPCH_EG_DLG_SEC_ID Character(100) VARCHAR2(100) NOT NULL Dialog Section
    10 GPCH_EG_DIA_ID Number(5,0) INTEGER NOT NULL Dialog Response ID
    11 GPCH_EG_LBL Long Character CLOB Dialog Response Label
    12 GPCH_EG_DLG_ANSWER Character(1) VARCHAR2(1) NOT NULL Dialog Answer Elements
    13 GPCH_EG_DLG_STRING Character(125) VARCHAR2(125) NOT NULL Dialog Answer String
    14 GPCH_EG_DLG_V_STR Character(125) VARCHAR2(125) NOT NULL Dialog Answer String
    15 GPCH_EG_DLG_DATE Date(10) DATE Dialog Answer Date
    16 GPCH_EG_DLG_BOLEAN Character(1) VARCHAR2(1) NOT NULL Dialog Response boolean
    N=No
    Y=Yes
    17 GPCH_EG_DLG_HH_MM Character(5) VARCHAR2(5) NOT NULL Dialog Response hours minutes
    18 GPCH_EG_DLG_DTYPE Character(20) VARCHAR2(20) NOT NULL Dialog Answer Data Type
    19 GPCH_EG_DLG_ORDER Number(3,0) SMALLINT NOT NULL Dialog Order