Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

PreOrder - BYU - Brigham Young University Home

VIEWS: 3 PAGES: 18

									                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V1         V2           V3             V4              V5           V6           V7                    V8                V9              V10
TYPE ID    NEXT ISSUE   WO_NUMBER      PREORD_NUMBER   ACTION       PRIORITY     DEPARTMENT_NUMBER     CONTACT_USER_ID   CONTACT_LNAME   CONTACT_FNAME
VARCHAR2   VARCHAR2     NUMBER         NUMBER          VARCHAR2     VARCHAR2     VARCHAR2              VARCHAR2          VARCHAR2        VARCHAR2
2          1            7              16              20           7            15                    40                20              20
OPTIONAL   OPTIONAL     OPTIONAL       OPTIONAL        OPTIONAL     OPTIONAL     OPTIONAL              OPTIONAL          OPTIONAL        OPTIONAL
DP                                                     Change       Medium       AL-22-1819            jmarshall
DP                                                     Disconnect   Medium       AL-22-1819            jmarshall
DP                                                     Move         Medium       AZ-48-1912            schase
DP                                                     Change       Medium       LA-18-1812            jrutledge
DP                                                     Disconnect   Medium       LA-18-1812            jrutledge
DP                                                     Change       Medium       LA-18-1812            jrutledge
DP                                                     Disconnect   Medium       LA-18-1812            jmarshall
DP                                                     Change       Medium       LA-18-1812            jrutledge
DP                                                     Change       Medium       NY-11-1788            jmarshall
DP                                                     Change       Medium       NY-11-1788            jmarshall
DP                                                     Disconnect   Medium       NY-11-1788            jrutledge
DP                                                     Change       Medium       NY-11-1788            jrutledge
DP                                                     Change       Medium       NY-11-1788            jmarshall
DP                                                     Change       Medium       NY-11-1788            jmarshall
DP                                                     Change       Medium       NY-11-1788            jmarshall
DP                                                     Disconnect   Medium       NY-11-1788            jrutledge
FR                                                     Add          Medium       LA-18-1812            jmarshall
TT                                                     Trouble      Medium       AL-22-1819            jmarshall
TT                                                     Trouble      Medium       AZ-48-1912            schase
TT                                                     Trouble      Medium       AZ-48-1912            jmarshall




  Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
  Last Modified: 01-Jul-2004                                                                                                                   Page 1 of 18
                                                                                PreOrder
                                                                     PINNACLE Import Data File Layout


V11            V12              V13               V14                  V15                  V16                V17              V18
CONTACT_NPA    CONTACT_NPX      CONTACT_NXX       MAC_EST_START_DT     MAC_EST_END_DT       MAC_ACT_START_DT   MAC_ACT_END_DT   MAC_INSPECTION_DT
VARCHAR2       VARCHAR2         VARCHAR2          DATE                 DATE                 DATE               DATE             DATE
3              3                4                 DD-MON-RRRR          DD-MON-RRRR          DD-MON-RRRR        DD-MON-RRRR      DD-MON-RRRR
OPTIONAL       OPTIONAL         OPTIONAL          OPTIONAL             OPTIONAL             OPTIONAL           OPTIONAL         OPTIONAL
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  23-Jun-2004          25-Jun-2004
                                                  22-Jun-2004          23-Jun-2004
                                                  22-Jun-2004          23-Jun-2004
                                                  22-Jun-2004          23-Jun-2004




  Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
  Last Modified: 01-Jul-2004                                                                                                                   Page 2 of 18
                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V19                       V20                V21             V22                       V23                    V24                V25
MAC_INSPECTION_CODE       TIK_TROUBLE_ID     TIK_REASON_ID   TIK_REPORTED_DATETIME     TIK_CLEARED_DATETIME   SERVICE_TYPE       OLD_SERVICE_NUMBER
VARCHAR2                  VARCHAR2           VARCHAR2        DATE                      DATE                   VARCHAR2           VARCHAR2
8                         3                  3               DD-MON-RRRR HH:MM         DD-MON-RRRR HH:MM      20                 60
OPTIONAL                  OPTIONAL           OPTIONAL        OPTIONAL                  OPTIONAL               OPTIONAL           OPTIONAL
                                                                                                              Voice              5853403002
                                                                                                              Wireless           00-B0-D0-B1-02-AC
                                                                                                              Voice              5853403004
                                                                                                              Cable TV           CATV-112
                                                                                                              Calling Card       8380694012
                                                                                                              Cellular           5853819112
                                                                                                              PBN                PBN-1012
                                                                                                              Pager              5855557812
                                                                                                              Calling Card       8380694021
                                                                                                              Cellular           5853819134
                                                                                                              PBN                PBN-1034
                                                                                                              Voice              5853402034
                                                                                                              Wireless           00-10-A4-A7-01-AB
                                                                                                              Cellular           5853819132
                                                                                                              Calling Card       8380694008
                                                                                                              Ethernet           IDF-W1200-PPA1-115
                                                                                                              Voice
                                                                                                              Inbound Tollfree   8770221819
                                                                                                              Inbound Tollfree   8770481912
                                                                                                              Wireless           00-B0-D0-D1-04-BC




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                                         Page 3 of 18
                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V26                      V27                 V28         V29        V30                   V31                  V32                  V33
OLD_PRIVATE_NUMBER       OLD_BUILDING_ID     OLD_FLOOR   OLD_ROOM   OLD_JACK              NEW_SERVICE_NUMBER   NEW_PRIVATE_NUMBER   NEW_BUILDING_ID
VARCHAR2                 VARCHAR2            VARCHAR2    VARCHAR2   VARCHAR2              VARCHAR2             VARCHAR2             VARCHAR2
60                       10                  18          18         30                    60                   60                   10
OPTIONAL                 OPTIONAL            OPTIONAL    OPTIONAL   OPTIONAL              OPTIONAL             OPTIONAL             OPTIONAL
3002                     LIBRARY             1st         1005       IDF-LIB1-PBA1-1005    5853403002           3002                 LIBRARY
00-B0-D0-B1-02-AC
3004                     LIBRARY             1st         1015       IDF-LIB1-PBA1-1015    5853403004                                ADMIRAL
CATV-112                 WHITEHOUSE          1st         1104       IDF-E1100-CTV1-104    CATV-112             CATV-112             WHITEHOUSE
2221
5853819112                                                                                5853819112           5853819112
7734259
5855557812                                                                                5855557812           5855557812
2374                                                                                      8380694021           2374
5853819134                                                                                5853819134           5853819134
7777775
2034                     WHITEHOUSE          2nd         2108       IDF-E2100-PBA2-208    5853402034           2034                 WHITEHOUSE
00-10-A4-A7-01-AB                                                                         00-10-A4-A7-01-AB    00-10-A4-A7-01-AB
5853819132                                                                                5853819132           5853819132
2153                                                                                      8380694008           2153
IDF-W1200-PPA1-115       WHITEHOUSE          1st         1215       IDF-W1200-PPA1-115
                                                                                                                                    WHITEHOUSE
8770221819
8770481912
00-B0-D0-D1-04-BC




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                                    Page 4 of 18
                                                                      PreOrder
                                                           PINNACLE Import Data File Layout


V34             V35           V36
NEW_FLOOR       NEW_ROOM      NEW_JACK
VARCHAR2        VARCHAR2      VARCHAR2
18              18            30
OPTIONAL        OPTIONAL      OPTIONAL
1st             1005          IDF-LIB1-PBA1-1005

1st             102           IDF-S100-PBA2-102
1st             1104          IDF-E1100-CTV1-104




2nd             2108          IDF-E2100-PBA2-208




3rd             3102          IDF-E3100-PPA1-302




      Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
      Last Modified: 01-Jul-2004                                                              Page 5 of 18
                                                                                             PreOrder
                                                                                 PINNACLE Import Data File Layout


V37                                                                                                                      V38             V39
COMMENT_TEXT                                                                                                             SUBSCRIBER_ID   SUBSCRIBER_USER_ID
VARCHAR2                                                                                                                 NUMBER          VARCHAR2
2000                                                                                                                     7               20
OPTIONAL                                                                                                                 OPTIONAL        OPTIONAL
                                                                                                                                         AL-22-1819
                                                                                                                                         AL-22-1819
Moving to the Admiral building as part of the construction project                                                                       AZ-48-1912
                                                                                                                                         1218491850
                                                                                                                                         1218491850
Upgrade to premire package                                                                                                               1218491850
                                                                                                                                         1218491850
Please change phone number because this one is too close to the main phone number                                                        1218491850
Can you please change my dialing permissions to support international calling                                                            2118811885
Please upgrade phone to premiere package                                                                                                 3419531961
                                                                                                                                         3419531961
Please upgrade to M2616 digital phone                                                                                                    3419531961
I want to my office phone and go to complete digital services. I just discovered that my office is being recorded                        3719691974
I will be traveling overseas to meet with Winston. So I need to have my cellular service upgraded with the GSM package                   3219331945
Upgrade to support overseas calling                                                                                                      818371941
                                                                                                                                         818371941
                                                                                                                                         1218491850
Service Not Working                                                                                                                      AL-22-1819
                                                                                                                                         AZ-48-1912
Can not connect to network                                                                                                               AZ-48-1912




    Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
    Last Modified: 01-Jul-2004                                                                                                                   Page 6 of 18
                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V40               V41                           V42             V43                        V44                V45              V46           V47
NEW_SUBSCRIBER    SUBSCRIBER_FIRST_NAME         SUBSCRIBER_MI   SUBSCRIBER_LAST_NAME       SUBSCRIBER_GROUP   ASSIGNED_TO_ID   DUE_DATE      RECEIVE_DATE
VARCHAR2          VARCHAR2                      VARCHAR2        VARCHAR2                   VARCHAR2           VARCHAR2         DATE          DATE
1                 15                            1               20                         20                 9                DD-MON-RRRR   DD-MON-RRRR
OPTIONAL          OPTIONAL                      OPTIONAL        OPTIONAL                   OPTIONAL           OPTIONAL         OPTIONAL      OPTIONAL
N                                                               Facilities (Alabama        GL Subscribers     CUSTSERV
N                                                               Facilities (Alabama        GL Subscribers     CUSTSERV
N                                                               Purchasing (Arizona        GL Subscribers     CUSTSERV
N                 Zachary                                       Taylor                     GL Subscribers     CUSTSERV
N                 Zachary                                       Taylor                     GL Subscribers     CUSTSERV
N                 Zachary                                       Taylor                     GL Subscribers     CUSTSERV
N                 Zachary                                       Taylor                     GL Subscribers     CUSTSERV
N                 Zachary                                       Taylor                     GL Subscribers     CUSTSERV
N                 Chester                       A               Arthur                     GL Subscribers     CUSTSERV
N                 Dwight                        D               Eisenhower                 GL Subscribers     CUSTSERV
N                 Dwight                        D               Eisenhower                 GL Subscribers     CUSTSERV
N                 Dwight                        D               Eisenhower                 GL Subscribers     CUSTSERV
N                 Richard                       M               Nixon                      GL Subscribers     CUSTSERV
N                 Franklin                      D               Roosevelt                  GL Subscribers     CUSTSERV
N                 Martin                                        VanBuren                   GL Subscribers     CUSTSERV
N                 Martin                                        VanBuren                   GL Subscribers     CUSTSERV
N                 Zachary                                       Taylor                     GL Subscribers     CUSTSERV
N                                                               Facilities (Alabama        GL Subscribers     CUSTSERV
N                                                               Purchasing (Arizona        GL Subscribers     CUSTSERV
N                                                               Purchasing (Arizona        GL Subscribers     CUSTSERV




  Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
  Last Modified: 01-Jul-2004                                                                                                                       Page 7 of 18
                                                                            PreOrder
                                                                 PINNACLE Import Data File Layout


V48                    V49               V50              V51           V52                         V53            V54
REQUISITION_NUMBER     PROJECT_TYPE      PROJECT_NUMBER   STATUS_DESC   SUSPEND_RESTORE_SVC         EST_REQUIRED   DEFAULT_MRC_EXP_ACCT
VARCHAR2               VARCHAR2          NUMBER           VARCHAR2      VARCHAR2                    VARCHAR2       VARCHAR2
12                     3                 16               50            1                           1              100
OPTIONAL               OPTIONAL          OPTIONAL         OPTIONAL      OPTIONAL                    OPTIONAL       OPTIONAL
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    Y
                                                                                                    N
                                                                                                    N
                                                                                                    N
                                                                                                    N




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                             Page 8 of 18
                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V55                         V56             V57            V58            V59            V60            V61            V62            V63            V64
DEFAULT_OCC_EXP_ACCT        USER_FIELD_1    USER_FIELD_2   USER_FIELD_3   USER_FIELD_4   USER_FIELD_5   USER_FIELD_6   USER_FIELD_7   USER_FIELD_8   USER_FIELD_9
VARCHAR2                    VARCHAR2        VARCHAR2       VARCHAR2       VARCHAR2       VARCHAR2       VARCHAR2       VARCHAR2       VARCHAR2       VARCHAR2
100                         20              20             20             20             20             20             20             20             20
OPTIONAL                    OPTIONAL        OPTIONAL       OPTIONAL       OPTIONAL       OPTIONAL       OPTIONAL       OPTIONAL       OPTIONAL       OPTIONAL




  Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
  Last Modified: 01-Jul-2004                                                                                                                             Page 9 of 18
                                                                                 PreOrder
                                                                      PINNACLE Import Data File Layout


V65             V66              V67               V68            V69              V70              V71            V72            V73            V74
USER_FIELD_10   USER_FIELD_11    USER_FIELD_12     USER_CKBOX_1   USER_CKBOX_2     USER_CKBOX_3     USER_CKBOX_4   USER_CKBOX_5   USER_CKBOX_6   USER_DATE_1
VARCHAR2        VARCHAR2         VARCHAR2          VARCHAR2       VARCHAR2         VARCHAR2         VARCHAR2       VARCHAR2       VARCHAR2       DATE
20              20               20                1              1                1                1              1              1              DD-MON-RRRR
OPTIONAL        OPTIONAL         OPTIONAL          OPTIONAL       OPTIONAL         OPTIONAL         OPTIONAL       OPTIONAL       OPTIONAL       OPTIONAL




                                                                                                                   1

                                                                                                                   1



                                                                                                                                                 1-Jul-2004




                                                   1                                                               1




                                                   1                               1
                                                                  1                1
                                                                  1                                                1




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                                         Page 10 of 18
                                                                              PreOrder
                                                                   PINNACLE Import Data File Layout


V75           V76             V77              V78           V79                    V80                   V81                 V82
USER_DATE_2   USER_DATE_3     USER_DATE_4      USER_DATE_5   USER_DOLLAR_1_FIELD    USER_DOLLAR_1_FIELD   USER_LIST_VALUE_1   USER_LIST_VALUE_2
DATE          DATE            DATE             DATE          NUMBER                 NUMBER                VARCHAR2            VARCHAR2
DD-MON-RRRR   DD-MON-RRRR     DD-MON-RRRR      DD-MON-RRRR   16,2                   16,2                  40                  40
OPTIONAL      OPTIONAL        OPTIONAL         OPTIONAL      OPTIONAL               OPTIONAL              OPTIONAL            OPTIONAL
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0
                                                             0                      0




  Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
  Last Modified: 01-Jul-2004                                                                                                                      Page 11 of 18
                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V83                   V84                    V85                 V86                  V87                 V88                 V89
USER_LIST_VALUE_3     SERV_USER_FIELD_1      SERV_USER_FIELD_2   SERV_USER_FIELD_3    SERV_USER_FIELD_4   SERV_USER_FIELD_5   SERV_USER_FIELD_6
VARCHAR2              VARCHAR2               VARCHAR2            VARCHAR2             VARCHAR2            VARCHAR2            VARCHAR2
40                    40                     40                  40                   40                  40                  40
OPTIONAL              OPTIONAL               OPTIONAL            OPTIONAL             OPTIONAL            OPTIONAL            OPTIONAL




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                                     Page 12 of 18
                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V90                   V91                    V92                 V93                   V94                  V95                  V96
SERV_USER_FIELD_7     SERV_USER_FIELD_8      SERV_USER_FIELD_9   SERV_USER_FIELD_10    SERV_USER_FIELD_11   SERV_USER_FIELD_12   SERV_USER_FIELD_13
VARCHAR2              VARCHAR2               VARCHAR2            VARCHAR2              VARCHAR2             VARCHAR2             VARCHAR2
40                    40                     40                  40                    40                   40                   40
OPTIONAL              OPTIONAL               OPTIONAL            OPTIONAL              OPTIONAL             OPTIONAL             OPTIONAL




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                                    Page 13 of 18
                                                                               PreOrder
                                                                    PINNACLE Import Data File Layout


V97                    V98                      V99                V100                   V101               V102               V103
SERV_USER_FIELD_14     SERV_USER_FIELD_15       SERV_USER_CBOX_1   SERV_USER_CBOX_2       SERV_USER_CBOX_3   SERV_USER_CBOX_4   SERV_USER_CBOX_5
VARCHAR2               VARCHAR2                 VARCHAR2           VARCHAR2               VARCHAR2           VARCHAR2           VARCHAR2
40                     40                       1                  1                      1                  1                  1
OPTIONAL               OPTIONAL                 OPTIONAL           OPTIONAL               OPTIONAL           OPTIONAL           OPTIONAL




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                                      Page 14 of 18
                                                                             PreOrder
                                                                  PINNACLE Import Data File Layout


V104                 V105                   V106               V107                 V108               V109               V110
SERV_USER_CBOX_6     SERV_USER_CBOX_7       SERV_USER_CBOX_8   SERV_USER_CBOX_9     SERV_USER_DATE_1   SERV_USER_DATE_2   SERV_USER_DATE_3
VARCHAR2             VARCHAR2               VARCHAR2           VARCHAR2             DATE               DATE               DATE
1                    1                      1                  1                    DD-MON-RRRR        DD-MON-RRRR        DD-MON-RRRR
OPTIONAL             OPTIONAL               OPTIONAL           OPTIONAL             OPTIONAL           OPTIONAL           OPTIONAL




  Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
  Last Modified: 01-Jul-2004                                                                                                                 Page 15 of 18
                                                                              PreOrder
                                                                   PINNACLE Import Data File Layout


V111                     V112                      V113                 V114                     V115                     V116
SERV_USER_DOLLAR_1       SERV_USER_DOLLAR_2        SERV_USER_DOLLAR_3   SERV_USER_DOLLAR_4       SERV_USER_LIST_VALUE_1   SERV_USER_LIST_VALUE_2
NUMBER                   NUMBER                    NUMBER               NUMBER                   VARCHAR2                 VARCHAR2
16,2                     16,2                      16,2                 16,2                     40                       40
OPTIONAL                 OPTIONAL                  OPTIONAL             OPTIONAL                 OPTIONAL                 OPTIONAL




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                                  Page 16 of 18
                                                                            PreOrder
                                                                 PINNACLE Import Data File Layout


V117                         V118                       V119                       V120                     V121
SERV_USER_LIST_VALUE_3       SERV_USER_LIST_VALUE_4     SERV_USER_LIST_VALUE_5     SERV_USER_LIST_VALUE_6   SERV_USER_LIST_VALUE_7
VARCHAR2                     VARCHAR2                   VARCHAR2                   VARCHAR2                 VARCHAR2
40                           40                         40                         40                       40
OPTIONAL                     OPTIONAL                   OPTIONAL                   OPTIONAL                 OPTIONAL




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                                                        Page 17 of 18
                                                                              PreOrder
                                                                   PINNACLE Import Data File Layout


V122                         V123                       V124                         V125
SWITCH_TYPE                  SWITCH_NAME                MDN_SVC                      CREATED_BY
VARCHAR2                     VARCHAR2                   VARCHAR2                     VARCHAR2
20                           30                         1                            15
OPTIONAL                     OPTIONAL                   OPTIONAL                     OPTIONAL




   Filename: 35862882-adf2-41ea-abf5-3e9293e94bc2.xls
   Last Modified: 01-Jul-2004                                                                         Page 18 of 18

								
To top