GPAR_NRP_GLG_VW

(SQL View)
Index Back

ARG Generic Report Setup - PIN

GP ARG Child record for the Generic Report Setup - Row/Col

SELECT GP_GENRPT_ID , SEQNUM , SEQNBR , PIN_NUM + 50000000 , LANGUAGE_CD , GPAR_DESCR_250 FROM PS_GPAR_RPTPIN_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 GP_GENRPT_ID Character(10) VARCHAR2(10) NOT NULL Code of the generic report
2 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
3 SEQNBR Number(5,0) INTEGER NOT NULL Sequence Number
4 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number

Prompt Table: %GP_EDIT_FLD7

5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
6 GPAR_DESCR_250 Character(250) VARCHAR2(250) NOT NULL Description