EX_DCAA_AET

(SQL Table)
Index Back

DCAA Notification State Record

DCAA 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