OPRIDDefault Value: PRCSRUNCNTL.OPRID
RUN_CNTL_IDDefault Value: PRCSRUNCNTL.RUN_CNTL_ID
A=All Statuses Summary
C=Consent
N=Reset-Include in Import file
R=Reset-Exclude from Import file
W=Withdrawn
Default Value: A
RC_US_EXP(SQL Table) |
Index Back |
|---|---|
Employee ConsentUsed in Self-Service Year-End Forms. This record stores employee consent information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: PRCSRUNCNTL.OPRID |
| 2 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL |
Run Control ID
Default Value: PRCSRUNCNTL.RUN_CNTL_ID |
| 3 | FROMDATE | Date(10) | DATE | From Date |
| 4 | THRUDATE | Date(10) | DATE | End Date |
| 5 | EXP_CONSENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This field will store the employees consent actions.
A=All Statuses Summary C=Consent N=Reset-Include in Import file R=Reset-Exclude from Import file W=Withdrawn Default Value: A |