GPFR_ILL_RUNCTL(SQL Table) |
Index Back |
|---|---|
Run control ILL + ATMPRun control Illness/Maternity, Long-Term Illness and Industrial Accident/Occupational Illness Certificates. Used in the retrieval of datas so as to full fill and print the previous Certificates. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Prompt Table: OPERATOR_VW |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 3 | GB_GROUP_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Group Build ID.
Prompt Table: GB_GROUP_TBL |
| 4 | CAL_RUN_ID |
Character(18) | VARCHAR2(18) NOT NULL | Calendar Run Id |
| 5 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 6 | GPFR_ILL_PREP | Character(1) | VARCHAR2(1) NOT NULL |
Different families of absence codes
Y/N Table Edit Default Value: N |
| 7 | GPFR_AT_PREP | Character(1) | VARCHAR2(1) NOT NULL |
Different families of absence codes
Y/N Table Edit Default Value: N |
| 8 | GPFR_AT_PERIOD_FDT | Date(10) | DATE | GPFR: Beginning of the ref period |
| 9 | GPFR_AT_PERIOD_TDT | Date(10) | DATE | GPFR: End of the Ref Period |
| 10 | GB_EFFDT | Date(10) | DATE | Group As Of Date |
| 11 | GB_REFINE_DATE | Date(10) | DATE | Refinement Date |
| 12 | GPFR_ILL_NAME | Character(50) | VARCHAR2(50) NOT NULL | GPFR: Name of the Signatory |
| 13 | GPFR_ASS_SIGN_STS | Character(2) | VARCHAR2(2) NOT NULL |
Status of the person who will sign the certificate
01=Managing Director 02=Manager 03=Director 04=Personnel Manager 05=Accountant 06=Receiver 07=Compulsory Liquidator 08=Other |
| 14 | GPFR_ASS_SIGN_STAT | Character(30) | VARCHAR2(30) NOT NULL | GPFR: Other Status of the Signatory |
| 15 | GPFR_ASS_PLACE_SIG | Character(30) | VARCHAR2(30) NOT NULL | GPFR: Place for Signature |
| 16 | GPFR_ASS_SIG_DATE | Date(10) | DATE |
GPFR: Date of Signature
Default Value: %date |