GPIN_F16_RPT_VW

(SQL View)
 Index Back

Form 16 Report View

Used to hold the filename for Form 16/12BA for each employee,Estabid & Assessment Year combination. The XML String in this table is used as Data Source by Form16 BI Publisher to showup Form 16/12BA report for employees on their login.

SELECT EMPLID , ESTABID , GPIN_ASSMNT_YR , 'GPIN_FORM16_SRC' , EMPLID||'_'||ESTABID||'_'||%Substring( GPIN_ASSMNT_YR ,3 ,2)||'-'||%Substring( GPIN_ASSMNT_YR ,10 ,2)||'.pdf' AS FILENAME , RAWXML FROM %Table(GPIN_F16_RPT)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ESTABID Character(12) VARCHAR2(12) NOT NULL Establishment ID
3 GPIN_ASSMNT_YR Character(15) VARCHAR2(15) NOT NULL Assessment Year
4 URL_ID Character(30) VARCHAR2(30) NOT NULL URL Identifier (see PSURLDEFN).
5 FILENAME Character(80) VARCHAR2(80) NOT NULL File Name
6 RAWXML Long Character CLOB Raw XML