PROCESS_INSTANCEN=No
Y=Yes
EX_DCAA_AET(SQL Table) |
Index Back |
|---|---|
DCAA Notification State RecordDCAA Notification State Record |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 3 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | AE_APPLID | Character(12) | VARCHAR2(12) NOT NULL | Program Name (see PSAEAPPLDEFN). |
| 5 | AE_SECTION | Character(8) | VARCHAR2(8) NOT NULL | Section |
| 6 | SELECT_ALL | Character(1) | VARCHAR2(1) NOT NULL | Select All |
| 7 | SEND_REMINDER | Character(1) | VARCHAR2(1) NOT NULL |
Send reminder
N=No Y=Yes |
| 8 | BUSINESS_UNIT_GL | Character(5) | VARCHAR2(5) NOT NULL | GL Business Unit |
| 9 | NOTIFY_PASTDUE | Character(1) | VARCHAR2(1) NOT NULL | Past Due Notice |
| 10 | NOTIFY_ACKNOWLEDGE | Character(1) | VARCHAR2(1) NOT NULL | Pending Acknowledgement |
| 11 | DCAA_APPL_FLG | Character(1) | VARCHAR2(1) NOT NULL | DCAA Enabled |
| 12 | OVERRIDE_DCAA_FLG | Character(1) | VARCHAR2(1) NOT NULL | Disable DCAA |
| 13 | TIME_SHEET_ID | Character(10) | VARCHAR2(10) NOT NULL | Time Sheet Unique Identifier (System Generated) |
| 14 | VERSION_NUM | Number(3,0) | SMALLINT NOT NULL | Version Number |
| 15 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 16 | PERIOD_END_DT | Date(10) | DATE | Represents the date termination point for a given time set utilized in cash worksheet processing. |
| 17 | SUBMISSION_DATE | Date(10) | DATE | Submission Date |
| 18 | RESUBMISSION_DT | Date(10) | DATE | Resubmission Date |
| 19 | OPRID_SUBMITTED_BY | Character(30) | VARCHAR2(30) NOT NULL | Operator Id of user submitting the transaction |
| 20 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 21 | DATE_UNDER_RPT | Date(10) | DATE | Date Under Report |
| 22 | CUTOFF_DAYS | Number(3,0) | SMALLINT NOT NULL | Cutoff Days |
| 23 | CUTOFF_TIME | Time(15) | TIMESTAMP | The settlement cutoff time for a given bank/counterparty. |
| 24 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 25 | RUNDTTM | DateTime(26) | TIMESTAMP | Run Date/Time |
| 26 | RUNTIME | Time(15) | TIMESTAMP | Process Scheduler Process Run Time |
| 27 | USER_OPRID | Character(30) | VARCHAR2(30) NOT NULL | User ID |
| 28 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
| 29 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 30 | USER_OPTION_VALUE | Character(30) | VARCHAR2(30) NOT NULL | User personalization option override value. |
| 31 | DATETIMEVAL1 | DateTime(26) | TIMESTAMP | DateTime Value |
| 32 | URL_1 | Character(254) | VARCHAR2(254) NOT NULL | URL #1 |
| 33 | URL_2 | Character(254) | VARCHAR2(254) NOT NULL | URL #2 |