GLRN_RECON_STATUSY/N Table Edit
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: Y
0=Other
1=Waiting to be Approved
2=Approved
3=Denied
4=Pushed Back
9=Deleted
Default Value: 0
GLRN_STATUS_TBL(SQL Table) |
Index Back |
|---|---|
Reconciliation Status TableUser configured status codes |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | GLRN_RECON_STATUS |
Character(1) | VARCHAR2(1) NOT NULL | Reconciliation Status |
| 2 | ENABLED | Character(1) | VARCHAR2(1) NOT NULL |
A flag indicates whether this row is enabled or not.
Y/N Table Edit |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 4 | SHORT_DESCR | Character(15) | VARCHAR2(15) NOT NULL | This field is used to represent the short description for various objects |
| 5 | ACTION_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Status Action |
| 6 | ALLOW_DELETES_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Recreate
Y/N Table Edit Default Value: N |
| 7 | ALLOW_UPDATE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Allow Assignment Update
Y/N Table Edit Default Value: Y |
| 8 | GLRN_STATUS_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Reconciliation Status Types
0=Other 1=Waiting to be Approved 2=Approved 3=Denied 4=Pushed Back 9=Deleted Default Value: 0 |