ACTIONPrompt Table: ACTION_TBL
ACTION_REASONPrompt Table: ACTN_REASON_TBL
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
ACT_RSN_TBL_GER(SQL Table) |
Index Back |
|---|---|
Action/Reason CombinationsACTN_REASON_TBL is an edit table. Use it to record combinations of action codes and the reason codes that are valid for an action. For example, two valid reasons for a termination action might be attendance and misconduct. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ACTION |
Character(3) | VARCHAR2(3) NOT NULL |
Action
Prompt Table: ACTION_TBL |
| 2 | ACTION_REASON |
Character(3) | VARCHAR2(3) NOT NULL |
Reason Code
Prompt Table: ACTN_REASON_TBL |
| 3 | SPK_MAN_APPR_GER | Character(1) | VARCHAR2(1) NOT NULL |
Spokesmen Committee Approval
Y/N Table Edit Default Value: N |
| 4 | COMP_DR_APPR_GER | Character(1) | VARCHAR2(1) NOT NULL |
Company Doctor's Approval
Y/N Table Edit Default Value: N |
| 5 | SYSTEM_DATA_FLG | Character(1) | VARCHAR2(1) NOT NULL |
This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.
Y/N Table Edit Default Value: N |