RUN_CNTL_IDOPRIDPrompt Table: GPIN_ESTAB_VW
1=January-December
2=January-June
3=July-December
GPIN_FORMLWF_RC(SQL Table) |
Index Back |
|---|---|
LWF Runcontrol TableLWF Runcontrol Parameter Table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | ESTABID | Character(12) | VARCHAR2(12) NOT NULL |
Establishment ID
Prompt Table: GPIN_ESTAB_VW |
| 4 | GPIN_YEAR | Number(4,0) | SMALLINT NOT NULL | Year |
| 5 | BGN_DT | Date(10) | DATE | Begin Date |
| 6 | END_DT | Date(10) | DATE | end date |
| 7 | GPIN_LWF_CONTRIB | Character(1) | VARCHAR2(1) NOT NULL |
LWF Contribution Period
1=January-December 2=January-June 3=July-December |
| 8 | GPIN_LWF_OFFICE | Character(30) | VARCHAR2(30) NOT NULL | This field holds the value for LWF Local Office |
| 9 | GPIN_LWF_CHEQUE_NO | Character(10) | VARCHAR2(10) NOT NULL | This field holds the value of issued cheque number. |
| 10 | GPIN_LWF_CHEQ_DATE | Date(10) | DATE | This fields holds the issue date of a cheque. |
| 11 | GPIN_LWF_BANK_DTL | Character(30) | VARCHAR2(30) NOT NULL | This field holds the details of the bank provided. |