PY_DDP_ACTN_TBL(SQL Table) |
Index Back |
---|---|
Direct Deposit Action TableDirect Deposit Action Table for Job actions |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
2 | ACTION | Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL_VW |
3 | DDP_CTRL_ACTN | Character(1) | VARCHAR2(1) NOT NULL |
Direct Deposit Controls
I=Inactivate Direct Deposit P=Print Direct Deposit Advice |
4 | ACTION_REASON | Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_VW |
5 | DAYS_FRM_ACTN_DT | Signed Number(4,0) | DECIMAL(3) NOT NULL | Days from action Date |