GP_SYS_ADD_SRCH(SQL View) |
Index Back |
---|---|
Add System Element Srch ViewGlobal Payroll Add System Element Search View Record. |
%Sql(gp_add_sql) |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PIN_SYSTEM_NUM | Number(8,0) | INTEGER NOT NULL |
Element number field
Default Value: 99999999 |
2 | PIN_NUM | Number(8,0) | INTEGER NOT NULL | PIN Number |
3 | PIN_NM | Character(18) | VARCHAR2(18) NOT NULL | Element Name field |